Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hvanderborg
Contributor III
Contributor III

tWriteJSONField only outputs tree, how to pass other columns?

Hi,
When using tWriteJSONField it passes on the tree, but how can you pass on other columns in the flow to the next components?
Tried adding all columns to the schema of tWriteJSONField (Edit schema) but in output all are NULL except the field created with the json tree. Seems like a bug or could be a missing feature.
How can I pass on my data? Hope someone is willing to help out.
Thanks,
Henry
Labels (3)
3 Replies
Anonymous
Not applicable

Henry
Which component is the next component? Why you need to pass other column to the next component? Can you explain your request in detail?
Shong
Anonymous
Not applicable

Same problem here. The next component is tFileOutputDelimited. Previous component is tFileInputXML and I just want to merge 3 columns into 1 JSON column and keep all others columns untouched. But they output with null values. Can you help me please ? Shall I split flows with tReplicate before and merge them after the JSON component ?
Anonymous
Not applicable

Solution can be found here using this custom component : https://github.com/ijokarumawak/tRowToJSON