Json file having multiple arrays in diff columns

[Anonymous]

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

[Anonymous]

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