topic Re: HOW TO MERGE 2 XML IN A SINGLE FILE in Talend Studio

HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Sat, 16 Nov 2024 08:15:39 GMT

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

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 06:36:37 GMT

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

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Thu, 17 May 2018 06:48:38 GMT

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

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 06:55:08 GMT

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

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Thu, 17 May 2018 10:42:14 GMT

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,

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 12:46:28 GMT

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

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Thu, 17 May 2018 12:49:45 GMT

Hi,

Already provided in attached of my first post

Check it please

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 13:02:15 GMT

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

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Thu, 17 May 2018 13:09:58 GMT

It is currentDate that i put in global variable.

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

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 13:18:31 GMT

@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?

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 13:38:48 GMT

@mbocquet,still do you have issue?

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Thu, 17 May 2018 13:44:19 GMT

When i uncheck get Node, i get error bellow

Error Config: "Get Nodes" should be checked when type is "Document"
[ERROR]: vo2.job_de_test_0_1.Job_de_test - tFileInputXML_1 - Error Config: "Get Nodes" should be checked when type is "Document"

But by check it, i can read input file

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 13:51:11 GMT

@mbocquet,check with below i am getting.with you provided files and you can chech tFilInputXML settings also.

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 13:54:58 GMT

@mbocquet,what is the Loop XPath query in tFileInputXML?

can you use "/tototiti/ChouetteRoute" as Loop XPath query in tFileInputXML and let me know?

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Thu, 17 May 2018 14:06:26 GMT

By configured tFileInputXML like your screnshot, you cant' have a XML tree in your tXMLMap component i mean

Could you show me your txmlMap screenshot ?

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Thu, 17 May 2018 14:46:08 GMT

In my txmlmap,I do not have XML structure,since you can join objextId.

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Fri, 18 May 2018 06:14:47 GMT

@mbocquet,still if you have issue let me know ,i will provide Job export.

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Fri, 18 May 2018 08:30:05 GMT

Hi,

I still have issue, you can send it please.

In your job, your output is an XML file? And you get the same result like attached file ?

Thank you for help

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

manodwhb — Fri, 18 May 2018 08:46:14 GMT

@mbocquet,please find the attahced job export.

xmljoin.zip

Re: HOW TO MERGE 2 XML IN A SINGLE FILE

idembel2 — Fri, 18 May 2018 08:59:12 GMT

Thanks i check it and make you a feedback