Processor Json to CSV
Data In/ Data Out
JSON to CSV processor is a CSV auto flattening processor.
Data In |
The processor takes all CSV files from |
Data Out |
All flattened CSV files to |
Input files need to fit the following format:
- Multiple columns are
allowedallowed, - If a cell contains a scalar value (int, float, text, bool), it will be copied into output file 1:
11, - If the cell contains stringified JSON object (dictionary), it is flattened
appropriatelyappropriately.
If the cell contains stringified JSON object (array), another table with parent_id
is created in output files (component might create several output files, it depends on JSON data structure in the input file).
Example of input file: |
Directory:
Column1 = 42 (scalar value, this will be copied into output file as it is)
Column2 = JSON object (dictionary). This will be flattened appropriately in the output file.
Column3 = JSON object (array). Another table with |
Output files: |
2 files in
Content of
Content of
|