Need to load output from tExtractJsonFields as rows

[HemaS1]

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:

[HemaS1]

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

Thanks.

[Anonymous]

Hi,

could you please post your configuration from tExtractJsonFields?

[HemaS1]

Attached is the configuration. Thanks.

[Anonymous]

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.