https://community.qlik.com/t5/Talend-Studio/XML-field-in-the-table-how-to-validate/m-p/2366023#M129559 <P>Select your data from the table, parse the XML of the column, validate with your rule, write the parsed data back to the database.</P> <P>tDBinput -&gt; tExtractXMLFields -&gt; tDTDValidation, tXSDValidator or tJavaRow if your validation logic is not expressed in a schema -&gt; tDBRow</P> Thu, 13 Jun 2019 00:23:39 GMT nfz11 2019-06-13T00:23:39Z https://community.qlik.com/t5/Talend-Studio/XML-field-in-the-table-how-to-validate/m-p/2366022#M129558 <P>Hi there,</P> <P>&nbsp;</P> <P>I'm using Talend 5.6 open studio and MySQL as database.&nbsp; I need to validate the date and the price if it's valid or not.&nbsp; I have an xml field in the table and need to extract it to load to different columns.&nbsp; Because I have invalid dates and price, I would like to validate it if it's valid or not rather than excluding these records.&nbsp; How can I do that in Talend?</P> <P>&nbsp;</P> <P>Thank you,</P> <P>Melissa</P> Wed, 12 Jun 2019 14:20:24 GMT https://community.qlik.com/t5/Talend-Studio/XML-field-in-the-table-how-to-validate/m-p/2366022#M129558 Anonymous 2019-06-12T14:20:24Z https://community.qlik.com/t5/Talend-Studio/XML-field-in-the-table-how-to-validate/m-p/2366023#M129559 <P>Select your data from the table, parse the XML of the column, validate with your rule, write the parsed data back to the database.</P> <P>tDBinput -&gt; tExtractXMLFields -&gt; tDTDValidation, tXSDValidator or tJavaRow if your validation logic is not expressed in a schema -&gt; tDBRow</P> Thu, 13 Jun 2019 00:23:39 GMT https://community.qlik.com/t5/Talend-Studio/XML-field-in-the-table-how-to-validate/m-p/2366023#M129559 nfz11 2019-06-13T00:23:39Z