Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a text file with 2 columns:
The delimiter between the two columns are 2 pipe delimiters "||"
Example of the file:
apple tv||{"items":{"items": {"item":[{"itemId": 35364564576},{"itemId": 23425436456}]}}}
amazon echo||{"items":{"items": {"item":[{"itemId": 4563457657},{"itemId": 67868678678}]}}}
I need to build a job that extract the keyword and extract it's relevant items from the JSON
How I would like the output to look like:
Keyword | ItemID |
apple tv | 35364564576 |
apple tv | 23425436456 |
amazon echo | 4563457657 |
amazon echo | 67868678678 |
I know it might be very simple, but It's been a while since I used Talend and from some reason can't get it work.
Thanks in advance for your help!
Hi ,
Please find the job below to split json field.
Regards,
Hello,
I am trying to parse data from a JSON file I have, I am using tFileInputJson and logging the rows.
When the file has only one record, the job runs fine and give me the desired result.
But when the file has more than one record, I get the error "Unable to find next state", I am attaching all the files.
Could you please let me know how I can run this job for the file with multiple records.
Please help!
Thanks,
Alok