topic Re: how to convert json data to csv file?? in Talend Studio

how to convert json data to csv file??

amit_n — Sat, 16 Nov 2024 07:01:06 GMT

convert the json data to csv file. Data is having columns and inside the columns there is multiple fields. How to separate the fields to new colummsn.

Attached the file. Please let me know how to resolve this kind of problem.

"custom":{
"dimensions":[
{
"MessageType":"EventLog"
},
{
"Properties":"{\"user_AuthenticatedId\":\"17ada230-cd74-419a-971d-0a2f5c2a5518\",\"connectionState\":\"Online\",\"userName\":\"Sab Girish Parampoor\",\"pageUrl\":\"iOS - LoginViewController\",\"crmInstanceID\":\"e7ff6042-a8b8-e811-a974-000d3af4aec4\",\"timestamp\":\"2018-11-09 02:40:26 +0000\",\"pageDuration\":\"0\"}"
},
{
"AppBuild":"1.4.06"
},
{
"AppId":"30317700-3947-429b-9b10-887e463bcad6"
},

Properties column is having multiple fields. I need to separate fields to new columns.

Re: how to convert json data to csv file??

Anonymous — Wed, 19 Dec 2018 05:47:30 GMT

@Ait_nn

Please refer the below job flow for the solution.

Job flow

The details of the components are as below.

tFileInputJSON

tExtractJSONFields

Hope I have answered your query 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: how to convert json data to csv file??

amit_n — Wed, 19 Dec 2018 07:06:25 GMT

Actually columns like MessageType,propeties and other columns keeps on changing. its a dynamic columns. I can give the array position number in the path.

Re: how to convert json data to csv file??

Anonymous — Wed, 19 Dec 2018 09:26:39 GMT

Hi,

According to the business logic, you will have to make necessary arrangements. That I wold say you to try it by yourself 🙂

Community can help you to show the initial path. After that its your role to convert the path to super highway 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: how to convert json data to csv file??

Anonymous — Thu, 20 Dec 2018 06:26:56 GMT

@Ait_nn

Could you please mark the topic as resolved since your original query has been answered? It is a way of appreciation given to our fellow members for spending their time to resolve your query in between their own busy schedules.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂