Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to convert XML file with 2 different loops on the same level. I've tried to use tFileInputMSXML and tFileOutputMSXML for it. I was able to get all required data using tFileInputMSXML, but I couldn't connect different tFileInputMSXML outputs to single tFileOutputMSXML.
I have following input xml structure:
<getPropertyDescResult>
<clsProperty>
<strPropId>0171</strPropId>
<strName>Key 0171 Warm Sands Cool Water</strName>
...other general properties...
<arrPicList>
<clsPictureInfo>
<strURL> http://secure.......jpg</strURL>
<intWidth>288</intWidth>
<intHeight>216</intHeight>
<blnHasLargeImage>false</blnHasLargeImage>
</clsPictureInfo>
....other images....
</arrPicList>
<arrSeasonRates>
<clsSeasonRates>
<strChargeBasis>Daily</strChargeBasis>
<dtBeginDate>2013-01-01T00:00:00</dtBeginDate>
<dtEndDate>2013-03-16T00:00:00</dtEndDate>
<dblRate>270</dblRate>
</clsSeasonRates>
....other rates....
</arrSeasonRates>
</clsProperty>
</getPropertyDescResult>
and I want to get similar output xml.
Could you explain me hoe could I put results of these 3 schema to single XML output file ?
I've attached pictures with tFileInputMSXML and testing job.
I need to convert XML file with 2 different loops on the same level. I've tried to use tFileInputMSXML and tFileOutputMSXML for it. I was able to get all required data using tFileInputMSXML, but I couldn't connect different tFileInputMSXML outputs to single tFileOutputMSXML.
I have following input xml structure:
<getPropertyDescResult>
<clsProperty>
<strPropId>0171</strPropId>
<strName>Key 0171 Warm Sands Cool Water</strName>
...other general properties...
<arrPicList>
<clsPictureInfo>
<strURL> http://secure.......jpg</strURL>
<intWidth>288</intWidth>
<intHeight>216</intHeight>
<blnHasLargeImage>false</blnHasLargeImage>
</clsPictureInfo>
....other images....
</arrPicList>
<arrSeasonRates>
<clsSeasonRates>
<strChargeBasis>Daily</strChargeBasis>
<dtBeginDate>2013-01-01T00:00:00</dtBeginDate>
<dtEndDate>2013-03-16T00:00:00</dtEndDate>
<dblRate>270</dblRate>
</clsSeasonRates>
....other rates....
</arrSeasonRates>
</clsProperty>
</getPropertyDescResult>
and I want to get similar output xml.
Could you explain me hoe could I put results of these 3 schema to single XML output file ?
I've attached pictures with tFileInputMSXML and testing job.
Hi Shong, thanks for your answer. You have a small typo - each tHashInput should be linked with appropriate tHashOutput, not with tHashOutput1.
I've attached screenshot of my job.
I've tried this job with trigger OnSubjobOk and without it, in both cases it works fine. Could you tell me why have I got the same results ?
And one more question - I could connect OnSubjobOk trigger to only one tHashInput component, does it mean that all 3 tHashInput components would be synchronized with this single trigger or there is a way to connect OnSubJobOk trigger to each tHashInput component ?
I've attached screenshot of my job.
I've tried this job with trigger OnSubjobOk and without it, in both cases it works fine. Could you tell me why have I got the same results ?
And one more question - I could connect OnSubjobOk trigger to only one tHashInput component, does it mean that all 3 tHashInput components would be synchronized with this single trigger or there is a way to connect OnSubJobOk trigger to each tHashInput component ?
