topic how to extract the json data which are in single string column and convert to separate columns? in Talend Studio

how to extract the json data which are in single string column and convert to separate columns?

amit_n — Sat, 16 Nov 2024 06:36:24 GMT

Hi all,

I have urgent requirement. I have json file which are in single string line and having multiple columns . I need to separate the columns and their value in csv file. Attached the sample file please let me know how can i convert to json to csv file which are in single string value.

file is in txt format first convert the txt format to json format and try to convert the json data to csv file.

Re: how to extract the json data which are in single string column and convert to separate columns?

akumar2301 — Wed, 13 Feb 2019 11:06:09 GMT

you can use textractJsonfield

you need to complete above schema.

Sample result

Re: how to extract the json data which are in single string column and convert to separate columns?

amit_n — Wed, 13 Feb 2019 12:33:56 GMT

please can you let me know which is that input component u have used. M using talend open studio. can u please attach the job.

M facing the below error.

net.minidev.json.parser.ParseException: Unexpected End Of File position 0: null
Expected to find an object with property ['AuditDataSet'] in path $ but found 'java.lang.String'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.
Expected to find an object with property ['AuditDataSet'] in path $ but found 'java.lang.String'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.
net.minidev.json.parser.ParseException: Unexpected character (}) at position 0.

Re: how to extract the json data which are in single string column and convert to separate columns?

akumar2301 — Wed, 13 Feb 2019 13:39:21 GMT

input component

Re: how to extract the json data which are in single string column and convert to separate columns?

amit_n — Mon, 18 Feb 2019 09:20:20 GMT

thank you so much m able to extract the columns data.