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.
BR
Ondrej