Json extract not working as expected

[rk2019]

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

[root]

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).