topic How to convert raw json data to valid json format in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-convert-raw-json-data-to-valid-json-format/m-p/2297707#M70251 <P>Hi ,</P> <P>i have a postgress table where column data type is JSON, i am getting data in this column, how can i convert this column data into readable json format so that i can extract the coulmn data into multiple fields</P> <P>&nbsp;</P> <P>Urgent help is needed</P> <P>&nbsp;</P> <P>Regards,</P> <P>Murala</P> Wed, 08 Aug 2018 10:23:11 GMT muralam 2018-08-08T10:23:11Z How to convert raw json data to valid json format https://community.qlik.com/t5/Talend-Studio/How-to-convert-raw-json-data-to-valid-json-format/m-p/2297707#M70251 <P>Hi ,</P> <P>i have a postgress table where column data type is JSON, i am getting data in this column, how can i convert this column data into readable json format so that i can extract the coulmn data into multiple fields</P> <P>&nbsp;</P> <P>Urgent help is needed</P> <P>&nbsp;</P> <P>Regards,</P> <P>Murala</P> Wed, 08 Aug 2018 10:23:11 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-raw-json-data-to-valid-json-format/m-p/2297707#M70251 muralam 2018-08-08T10:23:11Z Re: How to convert raw json data to valid json format https://community.qlik.com/t5/Talend-Studio/How-to-convert-raw-json-data-to-valid-json-format/m-p/2297708#M70252 How does your data looks like and what is your expected output? Wed, 08 Aug 2018 12:20:06 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-raw-json-data-to-valid-json-format/m-p/2297708#M70252 iamabhishek 2018-08-08T12:20:06Z