How to join mutiple XMLs

Wed, 25 Nov 2020 16:16:04 GMT

Hi I am new to QV and I need help with loading multiple XMLs.

I have two xmls from two systems, with the same struture, each XML is divided into three tables.

I need to join the tables within the individual XML and then those joined tables I need to concatenate, since they have no fact in common, just the structure (facts are for different companies.

I have been trying this all day without any breakthrough.

so far I have:

// Start of [XML1_alfa_company.XML] LOAD statements

booking:

LOAD Reservation_Number,

Revenues_Total,

Revenues_CCY,

FileBaseName()& %Key_XML1_ED6FDEB6ED71A085, // Key to parent table: XML1

FileBaseName()& %Key_booking_C72069C72F8DBB37 // Key for this table: XML1/bookings/booking

FROM \\qvsrv\data\_QV_bookings\xml\XML1_alfa_company.XML (XmlSimple, Table is [XML1/bookings/booking]);

join

XML1:

LOAD Company,

Season,

FileBaseName()& %Key_XML1_ED6FDEB6ED71A085 // Key for this table: XML1

FROM \\qvsrv\data\_QV_bookings\xml\XML1_alfa_company.XML (XmlSimple, Table is [XML1]);

// End of [XML1_alfa_companyHUNKA.XML] LOAD statements

concatenate

booking:

LOAD Reservation_Number,

Revenues_Total,

Revenues_CCY,

FileBaseName()& %Key_XML1_ED6FDEB6ED71A085, // Key to parent table: XML1

FileBaseName()& %Key_booking_C72069C72F8DBB37 // Key for this table: XML1/bookings/booking

FROM \\qvsrv\data\_QV_bookings\xml\XML1_beta_company.XML (XmlSimple, Table is [XML1/bookings/booking]);

join

XML1:

LOAD Company,

Season,

FileBaseName()& %Key_XML1_ED6FDEB6ED71A085 // Key for this table: XML1

FROM \\qvsrv\data\_QV_bookings\xml\XML1_beta_company.XML (XmlSimple, Table is [XML1]);

// End of [XML1_beta_company.XML] LOAD statements

Thanks in advance for any kind of help.

Ondrej

topic How to join mutiple XMLs in QlikView

How to join mutiple XMLs