https://community.qlik.com/t5/Talend-Studio/how-to-transform-data-from-mysql-database-to-json-and-store-new/m-p/2352283#M118702 <P>I have data in mysql table called "skills" and I&nbsp;will have to convert the data into json data and store the new json data into postgresql. table into a cell, how can i do it?</P> Fri, 15 Nov 2024 21:36:52 GMT HSilwal03yr 2024-11-15T21:36:52Z https://community.qlik.com/t5/Talend-Studio/how-to-transform-data-from-mysql-database-to-json-and-store-new/m-p/2352283#M118702 <P>I have data in mysql table called "skills" and I&nbsp;will have to convert the data into json data and store the new json data into postgresql. table into a cell, how can i do it?</P> Fri, 15 Nov 2024 21:36:52 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transform-data-from-mysql-database-to-json-and-store-new/m-p/2352283#M118702 HSilwal03yr 2024-11-15T21:36:52Z https://community.qlik.com/t5/Talend-Studio/how-to-transform-data-from-mysql-database-to-json-and-store-new/m-p/2352284#M118703 <P>Hi </P><P>Take a look at tWriteJsonField, this component is used to write a json data string, please refer to <A href="https://help.talend.com/r/en-US/8.0/processing/twritejsonfield" alt="https://help.talend.com/r/en-US/8.0/processing/twritejsonfield" target="_blank">component documentation.</A> </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Wed, 30 Aug 2023 09:08:28 GMT https://community.qlik.com/t5/Talend-Studio/how-to-transform-data-from-mysql-database-to-json-and-store-new/m-p/2352284#M118703 Anonymous 2023-08-30T09:08:28Z