topic Strange tExtractJsonFields behaviour in Talend Studio

Strange tExtractJsonFields behaviour

Anonymous — Wed, 23 May 2018 14:24:56 GMT

Hi, I have JSON document stored in DB table and I need to extract those data in order to write them on MySQL. Here's an example of a JSON field I want to parse:

[{"val":"0","slotId":"T1","slotType":"ABS"},{"val":"0","slotId":"T2","slotType":"ABS"},{"val":"0","slotId":"T3","slotType":"ABS"},{"val":"0","slotId":"T4","slotType":"ABS"},{"val":"0","slotId":"TOT","slotType":"ABS"}]

and here's my tExtractJSONFields configuration:

Everything semmed to work but results are not like expected. In particular what I want is all same pod values on the same row, I got this instead:

What am I missing?

Re: Strange tExtractJsonFields behaviour

vboppudi — Wed, 23 May 2018 16:53:25 GMT

Hi Are you looking for the following output?

Regards,

Re: Strange tExtractJsonFields behaviour

Anonymous — Thu, 24 May 2018 15:53:12 GMT

Hi, Thank you for your reponse! I see you've set max function in tAggregateRow and this is not what I want.... suppose I've a DB with million of JSON documents like the one I've posted before and for each of them I need a row with all "Tx" fields (plus an ID field in order to join with other tables). I tried to replicate your configuration on my sample dataset which contains just 5 json entries, 2 of them lack of "T4" field. My sample dataset look like this:

And this is what I expect to see:

Thank you for your help!

Re: Strange tExtractJsonFields behaviour

vboppudi — Thu, 24 May 2018 15:55:05 GMT

Please provide data in file if possible.

Regards,

Re: Strange tExtractJsonFields behaviour

vboppudi — Thu, 24 May 2018 16:16:13 GMT

please try below

Regards,

Re: Strange tExtractJsonFields behaviour

Anonymous — Thu, 24 May 2018 16:19:24 GMT

here's the requested sample

sample.xlsx

Re: Strange tExtractJsonFields behaviour

vboppudi — Thu, 24 May 2018 16:33:47 GMT

Hi,

please follow the new approach.

Regards,

Re: Strange tExtractJsonFields behaviour

Anonymous — Thu, 24 May 2018 16:44:53 GMT

Cool, much better, pretty close... btw if you look at desired table posted above, I have two NULL values in T4 column due to missing field in corresponding jsons and I really need to keep this information. I tried to substitute zero in row2.slotId.equals("T2")?Float.parseFloat(row2.val):0 with null or even leaving it empty (I slightly modified your code since I want my data to be float type) but talend returns an error