Unique tExtractJSON read

Four Stars

Unique tExtractJSON read

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.

 Example_Data.PNG

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

Talend_Setup.PNG

 

Any idea on how I configure the Talend XPath query to achieve that result?

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads