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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Json file having multiple arrays in diff columns

I am having json file having diffrent arrays. When i use texttractjsonfileds component output came as below

hub|[1,2]|[100,500].

 

Actually i have to convert my data like

 

hub 1 100

hub 2 500

 

 

Please help me in this

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello,

How did you fill tExtractJSONfields? Your JSON Query for each column?

If you are extracting a simple array, please try to configure the input json in tfileinputjaon component and use tnormalize component to split the rows

tfileinputjson-->tnormalize-->tlogrow.

Best regards

Sabrina