Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
idembel2
Creator
Creator

HOW TO MERGE 2 XML IN A SINGLE FILE

Hi all,

I have 2 Input XML files which look like bellow:

 

File1 (file also in attach)

0683p000009LxgL.png

 

File2 (file also in attach)
0683p000009Lx35.png

 

 

 

 

 

 

 

 

Output file desired (file also in attach)
0683p000009LxgW.png

 

 

 

 

 

 

 

 

Thank you for help

 

 

 

Labels (5)
25 Replies
manodwhb
Champion II
Champion II

@mbocquet,still do you have issue?

idembel2
Creator
Creator
Author

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

manodwhb
Champion II
Champion II

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

0683p000009LxiM.png0683p000009LxiR.png

manodwhb
Champion II
Champion II

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

 

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

idembel2
Creator
Creator
Author

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

 

0683p000009Lxib.png

 

 

 

 

 

 

 

 

 

Could you show me your txmlMap screenshot ?

manodwhb
Champion II
Champion II

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

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

idembel2
Creator
Creator
Author

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

manodwhb
Champion II
Champion II

@mbocquet,please find the attahced job export.


xmljoin.zip
idembel2
Creator
Creator
Author

Thanks i check it and make you a feedback