Placing different XML contexts in a single row

[suneyes]

Hi all,

I am working on XML input stage where I am facing problem with XML contexts.

I am having a context like this

<tId>
<trId context="SUN/trId/0"> 59876543</trId>
<trId context="SUN/transId/0">12345678</trId>
<trId context="QUN/tradeId/0">1546382</trId>
</tId>

when I am selecting the columns for the XML input stage,I had selected both context and text of tId.

Now my requirement is to keep all the texts(59876543,12345678,1546382)
in a single row of a file.
There are some 1450 tId tags in my input XML file.
when I am redirecting the output from 'XML input' stage to a sequential firl,
I am getting 4350 columns.(1450*3).
This is because the system is creating a column for each context.
But I want all the 3 contexts in one row.


Any help regarding my problem is highly appreciated.

_________________

[throbinson]

I believe you are breaking on trId. TrId is your key column and your repetitive element. This would explain the 4350 rows.
Define a key column with .../tId as the description. this makes the column the repetitive element. This will break once per tId and put all the TrIDs within a tId in a single line.

[chulett]

And make sure you "Aggregate all rows".

[throbinson]

Aggregate all rows on the XML Input stage? Where?

[chulett]

XML Input? D'oh. Thought we was talking output.

[suneyes]

Thank you very much Mr. Robinson.
your inputs helped me in resolving my issue.
Thank you very much.

And thanks to you hulett.Thanks for your active participation