topic Creating XML with repeating elements in Data Quality

Creating XML with repeating elements

Anonymous — Sat, 16 Nov 2024 13:28:36 GMT

Hi,
I am trying to create an XML output using Delimited Input data. The output XML XSD has complex element type (repeating elements) to which I am unable to assign data.
Could you please help in this regard.
Sample Input
11|Sam|1|200|2|400|3|600
Expected Output
<?xml version="1.0" encoding="utf-8"?>
<OrdDet>
<CustID>11</CustID>
<CustName>Sam</custName>
<Orders>
<SubId>1</SubId>
<Amount>200</Amount>
</Orders>
<Orders>
<SubId>2</SubId>
<Amount>400</Amount>
</Orders>
<Orders>
<SubId>3</SubId>
<Amount>600</Amount>
</Orders>
</OrdDet>

Thanks in advance.
- Shankaran

Re: Creating XML with repeating elements

Anonymous — Wed, 07 Apr 2010 09:17:08 GMT

Hi,
Could somebody help with this request.
Thanks in adavnce.
Regards
Shankaran

Re: Creating XML with repeating elements

Anonymous — Wed, 07 Apr 2010 13:05:18 GMT

Hello
Here is a demo,
in.csv:

11|Sam|1|200|2|400|3|600

Code on tJavaRow:

output_row.CustID = input_row.CustID;
output_row.CustName = input_row.CustName;
output_row.conn=input_row.SubId1+","+input_row.Amount1+";"+input_row.SubId2+","+input_row.Amount2+";"+input_row.SubId3+","+input_row.Amount3;

tLogRow:

Starting job ddd at 20:00 07/04/2010.
.------+--------+-----+------.
|         tLogRow_1          |
|=-----+--------+-----+-----=|
|CustID|CustName|SubId|Amount|
|=-----+--------+-----+-----=|
|11    |Sam     |1    |200   |
|11    |Sam     |2    |400   |
|11    |Sam     |3    |600   |
'------+--------+-----+------'
Job ddd ended at 20:00 07/04/2010.

out.xml:

<?xml version="1.0" encoding="ISO-8859-15"?>
<OrdDet>
<CustID>11</CustID>
<CustName>Sam</CustName>
<Orders>
<SubId>1</SubId>
<Amount>200</Amount>
</Orders>
<Orders>
<SubId>2</SubId>
<Amount>400</Amount>
</Orders>
<Orders>
<SubId>3</SubId>
<Amount>600</Amount>
</Orders>
</OrdDet>

Best regards
Shong

Re: Creating XML with repeating elements

Anonymous — Thu, 08 Apr 2010 08:06:12 GMT

Hello

However I have a query on the right approach when there are numerous complex element types (number of repeating elements is dynamic).

Output them into the same xml file one by one using the feature 'append the source xml file'. About 'append the source xml file', see 5975.
Best regards
Shong

Re: Creating XML with repeating elements

Anonymous — Thu, 08 Apr 2010 16:19:07 GMT

Hi Shong,
Thanks a lot for your reply. I am not sure if I posted by query correctly (or prob did not understand ''append the source xml file" feature correctly).
In the sample message posted above <AlternateID>, <PriceQuantityAssociation>, <Token>, <Account> are some of the repeating elements. The values required to populate these repeating elements will come in a single record from source (ie all the required values willbe part of column in a single message).
Going by the example job given by you earlier , to concatenate and then to normalise on the concatenated column to populate the repeating elements, my query was ,
would we need to normalise data the number of times we have repeating/group elements ?
Is there a better approach / or am I missing some link here ?
Please advise.
Thanks in advance.
-Regards
Shankaran

Re: Creating XML with repeating elements

Anonymous — Mon, 12 Apr 2010 11:30:40 GMT

Hi,
Could you please help with this request.
Thanks in advance.
Regards
Shankaran