Extracting XML input with multiple repetative key elements
Posted: Thu Mar 15, 2012 12:42 am
Hi,
I have requirement to extract the xml file which looks like
<Start>
<SeqNo>12</SeqNo>
<DocRef>
<Eur_DocRef>A</Eur_DocRef>
<Eur_DocIdent>1</Eur_DocIdent>
<Eur_DocRef>B</Eur_DocRef>
<Eur_DocIdent>2</Eur_DocIdent>
<Eur_DocRef>C</Eur_DocRef>
<Eur_DocIdent>3</Eur_Docdent>
</DocRef>
</Start>
We have taken Eur_DocRef and Eur_DocIdent in separate link with a single key as repetative key element in XML input stage
and funneling all the data and remove duplicate based on all elements.
External_Source--->XML Input--(2 links for each repetitive key element)--> funnel-->remove duplicate--->sequential file
The output we got looks like
SeqNo Eur_Docref Eur_DocIdent
12 A 1
12 A 2
12 A 3
12 B 1
12 C 1
What we are expecting is
SeqNo Eur_Docref Eur_DocIdent
12 A 1
12 A 1
12 A 1
12 B 2
12 C 3
please help us on this
Regards,
Reddy
I have requirement to extract the xml file which looks like
<Start>
<SeqNo>12</SeqNo>
<DocRef>
<Eur_DocRef>A</Eur_DocRef>
<Eur_DocIdent>1</Eur_DocIdent>
<Eur_DocRef>B</Eur_DocRef>
<Eur_DocIdent>2</Eur_DocIdent>
<Eur_DocRef>C</Eur_DocRef>
<Eur_DocIdent>3</Eur_Docdent>
</DocRef>
</Start>
We have taken Eur_DocRef and Eur_DocIdent in separate link with a single key as repetative key element in XML input stage
and funneling all the data and remove duplicate based on all elements.
External_Source--->XML Input--(2 links for each repetitive key element)--> funnel-->remove duplicate--->sequential file
The output we got looks like
SeqNo Eur_Docref Eur_DocIdent
12 A 1
12 A 2
12 A 3
12 B 1
12 C 1
What we are expecting is
SeqNo Eur_Docref Eur_DocIdent
12 A 1
12 A 1
12 A 1
12 B 2
12 C 3
please help us on this
Regards,
Reddy