Great Explanation Krish. But one suggestion / advice. If you build the job on the fly, that will help others to understand much better Vs explaining the already built job. Hope you take it positively. Thank you.
Hi Srini I would think of one approach.. just consider the column in the table which has json content and map it to a target flat file and then use shell script to split the target file by each line. that way you will have multiple json file which u can again process it in Talend. If ur business requirement is to process in single job then refer to the below link hope that helps if not reach out to me with full business requirement community.talend.com/t5/Design-and-Development/Parse-JSON-column/m-p/53396#M17962
![แฉกลโกงงานวัด 2024 [ โกงมั้ยครับ ep.106 ] | DOM](http://i.ytimg.com/vi/taC5dpP3HXA/mqdefault.jpg)
Great Explanation Krish. But one suggestion / advice. If you build the job on the fly, that will help others to understand much better Vs explaining the already built job. Hope you take it positively. Thank you.
Anil K
please watch videos in sequence.
Nice Explanation...keep posted ....more Vedios
Excellent explanation... If it is possible plz make a vedio on Generic schema...
Please could you provide the XML file used in this video? thanks in advance
Is the code written in tjavarow is auto generated??
Durga prasad Sriramoji
It’s not auto generated
great, keep it up !
Can you help how to read a JSON stored in a MySQL table column and then create a file or output ??
Hi Srini
I would think of one approach.. just consider the column in the table which has json content and map it to a target flat file and then use shell script to split the target file by each line. that way you will have multiple json file which u can again process it in Talend. If ur business requirement is to process in single job then refer to the below link hope that helps if not reach out to me with full business requirement
community.talend.com/t5/Design-and-Development/Parse-JSON-column/m-p/53396#M17962
@@nagvamshi Do you mind sharing your contact number? I can call in your free time?
Java code used:- output_row.arg2 = StringHandling.EREPLACE(StringHandling.EREPLACE(input_row.arg2,"\\","");
Source xml file link drive.google.com/file/d/1D0Ywjadi425bSyn4xUI-GgdiHhPh_Ua5/view