topic Re: Need to load output from tExtractJsonFields as rows in Talend Studio

Need to load output from tExtractJsonFields as rows

HemaS1 — Fri, 15 Nov 2024 23:54:14 GMT

Hello,

I have the following scenario:

I am extracting employee data vis tHttpRequest and loading to a DB table.

When I extract the data and mapped to Json Fields I am getting each field value as a comma seperated values rather than individual row value to load into database.

For example=

departmentkey department user

'123',345',678 '.... | 'ClientService','Engineering','Support' ....| 'abc',def',ghi' ....

I need to load into Database table as:

departmentkey department user

-----------------------------------------------------

123 client Service abc

345 Engineering def

678 Support ghi

How can accomplish this?

The following is my current job flow:

Re: Need to load output from tExtractJsonFields as rows

HemaS1 — Mon, 02 Aug 2021 07:35:28 GMT

Hello, Can you elaborate your feedback? Is there any job that you can share?

Thanks.

Re: Need to load output from tExtractJsonFields as rows

Anonymous — Mon, 02 Aug 2021 08:36:43 GMT

Hi,

could you please post your configuration from tExtractJsonFields?

Re: Need to load output from tExtractJsonFields as rows

HemaS1 — Mon, 02 Aug 2021 19:13:08 GMT

Attached is the configuration. Thanks.

Re: Need to load output from tExtractJsonFields as rows

Anonymous — Fri, 06 Aug 2021 06:08:14 GMT

I believe the issue here is that you have $.*. on each Item Query. This should be removed. I could confirm more if you could share a sample JSON.