How to manually edit keys for XML load statements ?

shaktisinghchau — Wed, 25 Nov 2020 16:16:04 GMT

I want to load two xml files. They are using the same xsd. Because of differences in file content, the QlikView xml wizard creates different table structure for load statements. By manual edits in the XML load statements I have managed to load both the xml files in same table structure, but the key generation now fails.

With key fields i mean "fields that start with %Key_ as in the code below:

Payload:

LOAD xmlns,

[xmlns:xsi],

[RecordSet/RecordSetDate] as RecordSetDate,

[RecordSet/RecordSetType] as RecordSetType,

%Key_Payload_B02A2AB5DB894C01 // Key for this table: Payload

FROM [\\path\VXI_CS_HourChat_20160405_131520.xml] (XmlSimple, Table is [Payload]);

// End of [VXI_CS_HourCall_20160405_131513.xml] LOAD statements

My questions are :

How does QlikView define "tables" in xml files?
What is the syntax/logic behind the key generation in xml loads?
Can you edit the key fields manually, or must they be generated by the wizard?

topic How to manually edit keys for XML load statements ? in QlikView

How to manually edit keys for XML load statements ?