Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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