how to convert json data to csv file??

Highlighted
Six Stars

how to convert json data to csv file??

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.

 

 

 


Accepted Solutions
Highlighted
Employee

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

@Ait_nn

 

Please refer the below job flow for the solution.

Job flowJob flow

 

 

The details of the components are as below.

tFileInputJSONtFileInputJSON

 

tExtractJSONFieldstExtractJSONFields

 

 

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 :-)

 

 

 

 

View solution in original post


All Replies
Highlighted
Employee

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

@Ait_nn

 

Please refer the below job flow for the solution.

Job flowJob flow

 

 

The details of the components are as below.

tFileInputJSONtFileInputJSON

 

tExtractJSONFieldstExtractJSONFields

 

 

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 :-)

 

 

 

 

View solution in original post

Highlighted
Six Stars

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

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.

 

 

Highlighted
Employee

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

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 :-)

Employee

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

@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 :-)

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog