Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Hello, Can you elaborate your feedback? Is there any job that you can share?
Thanks.
Hi,
could you please post your configuration from tExtractJsonFields?
Attached is the configuration. Thanks.
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.