You are not logged in.
Announcement
Unanswered posts
|
Hi
When using tWriteJSONField, the fields which are not defined in JSON tree will not pass into next component.
You might use tFilterColumns to filter columns.
Regards,
Pedro
The components guide isn't really clear on exactly how to use this component. Here is my scenario...
I have a CSV file coming in that contains 6 columns:
Name, Description, Attribute 1, Attribute 2, Attribute 3, Attribute 4
My goal is to populate another file that contains three columns
Name, Description, Attributes
The Attributes column needs to contains a the JSON output from the Attribute columns in the original file. I do get this output, however the Name and Description columns are ending up null in the final output. I tried adding these to the Group By list, however that didn't make a difference.
Do I have to define ALL fields in the JSON tree, and those in GroupBy will be taken out of the JSON-formatted output?