Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vchuprina
Specialist
Specialist

Link between data

Hi All,

I load data from XML files as delimited files and need link data. For example:

<Programm name="CR10I0">

   <ReplacementTexts>

        <ReplacementText column="0" row="9" text="Alias Item:" originalText="Prt old part cd" />

</ReplacementTexts>

</Programm>

  <Programmname="CR10E0">

      <ReplacementTexts>

         <ReplacementText column="0" row="16" text="Free Shipment:" originalText="Harbor/airport:" />

</ReplacementTexts>

</Programm>

How can I link data: CR10I0 with 'Alias Item' and  CR10E0 with  'Free Shipment'

Thanks

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
4 Replies
Anonymous
Not applicable

Capture.PNG

Think you can load columns directly from the xml files. Once the table is created, relations are formed automatically.

vchuprina
Specialist
Specialist
Author

Hi,

I can't do this because I have more that 2000 xml files and they have different structure

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
Anonymous
Not applicable

In that case am helpless. Lets is someone else can help us out.

vishsaggi
Champion III
Champion III

May be look here:

Load Multiple XML Files