I have a JSON file like the below where I'm getting various values in the first position and then possibly a list of values in the second position.
I am trying to get the values in the first position to be stored as a Parent Code, and any values that may appear in the second position to be stored as the Child Code to it's corresponding parent. (ex. Parent Code: 2407M46 ITEM 2 Child Code: 2347M32 P01).
Any idea on how I configure the Talend XPath query to achieve that result?
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.