HOW TO MERGE 2 XML IN A SINGLE FILE

[idembel2]

Hi all,

I have 2 Input XML files which look like bellow:

File1 (file also in attach)

File2 (file also in attach)

Output file desired (file also in attach)

Thank you for help

[manodwhb]

@mbocquet,if the Name would be same in bothe XML's.then implemnt in the below way by join on Name

[idembel2]

Hi,
How to do it please, I have this idea but i try to map both file in a txmlMAp i got error
Thanks

[manodwhb]

Hi,please find below.i was doing join on skuid.

[idembel2]

Hi Manohar B,

That is exactly what i try to do, mapping both xml file to generate output XML File.

Find bellow my config of tFileInputXML component

Find bellow my config of tXMLMap component

But my output file is blank

Thanks,

[manodwhb]

@mbocquet,can you able to provide smaple source file?

[idembel2]

Hi,

Already provided in attached of my first post

Check it please

[manodwhb]

@mbocquet,what is the data type for "creationTime" from second file?

[idembel2]

It is currentDate that i put in global variable.

Don't worry about it, i put all field in string

[manodwhb]

@mbocquet,it was not getting values when i tick GetNodes in Basic settings>>Mapping of tFileInputXML.

so can you uncheck GetNodes in both tFileInputXML's and check?