Repeatative values in the xml input file

[Rimi]

Hi All ,


I am trying to do a small job:

Folder -> Xml Input -> Transformer -> Xml Output

but the problem is , i am not getting the same xml output for xml input . There are many repeatative values in the xml input file .

for example :
<address>
<city> xxx </city>
<street> sss </street>
</address>
<address>
<city> yyy </city>
<street> uuu </street>
</address>

So if i give city as key column in metadata ,then i will not get all values of street tag in output.
In transformation i am doing one-to-one mapping.
And one more thing i am not using xslt and xsd ..Is it necessary to use them?

can anyone help ?
Thanks in advance.

[chulett]

This sounds very similar to this post - are you perhaps working on the same problem? If so, let's please keep this to one discussion not two. Thanks.

If not - same question as in the other thread: what is your Output Mode set to? Try 'Single Row' if you have been aggregating rows.

[Rimi]

Thanks chulett..

I saw that my problem is same ...sorry for posting in different topic..from next time i will take care.