topic Re: Json file having multiple arrays in diff columns in Talend Studio

Json file having multiple arrays in diff columns

Anonymous — Mon, 19 Aug 2019 18:12:50 GMT

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

Re: Json file having multiple arrays in diff columns

Anonymous — Mon, 09 Sep 2019 07:54:48 GMT

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