Json extract not working as expected

rk2019 — Wed, 30 Sep 2020 14:11:14 GMT

Hi All,

I am using tfileinput json component to extract the exact field's values into CSV file output delimiter .However for some records field extract is different and corresponding value is coming from different array , infact the loop is jumping from one array to all of a sudden to a different array in the source file and printing different value as expected .

source json looks clean and didn't have any anomalies .

To test it further I manually copied the few arrays along with the culprit array to surprise, it was ok without any issues.

Please suggest what could be the reason and fix for this.Thanks

Re: Json extract not working as expected

root — Wed, 30 Sep 2020 15:40:14 GMT

I would propose using a more flexible component like tJsonDoc (its in the Talend Exchange). You can first read the json file as tFileInputRaw -> and read the contents as String and then pass the same to tJsonDoc components (tJsonDocOpen -> tJsonDocInput).

topic Json extract not working as expected in Talend Studio

Json extract not working as expected

Re: Json extract not working as expected