Hi,folks!
Please tell me how I need to parse this XML below with .xsd file with ValidateXML processor and .xsl file with TransformXML processor then send all of those attributes into relational DB with PutSQL and get the final table like (below)?:
|CNUM|clientName|qualInvestor|agreementNum|agreementService|agreementDate| => there are column names
|AAAAA|Batman Fargo| true | 33067 | blablabla | 2018-10-01 | => column values in row
|AAAAA|Batman Fargo| true | 55121 | blablabla | 2018-10-01 | => column values in row
|AAAAA|Batman Fargo| true | 60012 | blablabla | 2018-10-01 | => column values in row
Sorry for this "nice" table 🙂
<?xml version="1.0" encoding="UTF-8"?>
<clientList xmlns="http:blablabla" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="blablabla ClientList.xsd">
<client>
<CNUM>AAAAA</CNUM>
<clientName>Batman Fargo</clientName>
<qualInvestor>true</qualInvestor>
<agreementList>
<agreement>
<agreementNum>33067</agreementNum>
<agreementService>blablabla</agreementService>
<agreementDate>2018-10-01</agreementDate>
</agreement>
<agreement>
<agreementNum>55121</agreementNum>
<agreementService>blablabla</agreementService>
<agreementDate>2018-10-01</agreementDate>
</agreement> <agreement>
<agreementNum>60012</agreementNum>
<agreementService>blablabla</agreementService>
<agreementDate>2018-10-01</agreementDate>
</agreement>
</agreementList>
</client>
</clientList>