topic Re: XML with multiple loops in Talend Studio

XML with multiple loops

Conkers — Mon, 11 May 2020 14:39:47 GMT

I have the below XML document:

<blah>
	<blahblah>
		<XXXX>
			<number>
				<value>111111</value>
			</number>
			<detail>
				<data>Source 1</data>
			</detail>
		</XXXX>
		<XXXX>
			<number>
				<value>222222</value>
			</number>
			<detail>
				<data>Source 2</data>
			</detail>
		</XXXX>
	</blahblah>
	<XXXXset>
			<XXXX>
				<number>
					<desc>aaaaaa</desc>
					<value>123456</value>
				</number>
				<detail>
					<data>Source 2</data>
				</detail>
			</XXXX>
			<XXXX>
				<number>
					<desc>bbbbbb</desc>
					<value>458745</value>
				</number>
				<detail>
					<data>Source 2</data>
				</detail>
			</XXXX>
			<XXXX>
				<number>
					<desc>cccccc</desc>
					<value>000000</value>
				</number>
				<detail>
					<data>Source 1</data>
				</detail>
			</XXXX>
			<XXXX>
				<number>
					<desc>dddddd</desc>
					<value>8888585</value>
				</number>
				<detail>
					<data>Source 1</data>
				</detail>
			</XXXX>
			<XXXX>
				<number>
					<desc>eeeeee</desc>
					<value>668885</value>
				</number>
				<detail>
					<data>Source 2</data>
				</detail>
			</XXXX>					
	</XXXXset>
</blah>

I'm trying to loop on both the <blahblah> element and the <XXXXset> element, and then join them based on the <data> element (either Source 1 or Source 2).

Is this possible?

Talend Open Source 7.2.1

TIA

Re: XML with multiple loops

Anonymous — Tue, 12 May 2020 03:22:30 GMT

Hi
It is possible, use two tFileInputXML components to read the two loop elements separately, and then join the two input data flow on tMap. eg:
tFileInputXML1--main--tMap----out1--->tLogRow
|lookup
tFleinputXML2
This article might be helpful for you.
https://community.talend.com/t5/Design-and-Development/Doing-an-inner-join-using-a-tMap-component/ta-p/21572

Regards
Shong

Re: XML with multiple loops

Conkers — Tue, 12 May 2020 15:22:10 GMT

Thank you Shong, that was really helpful 🙂

Is there a way of combining the two tFileInputXML components with tWaitForFile or another way of selecting a file to run against this job?

TIA