Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview with multiple source XMLs export to XLS issue

Hi There,

I have an issue with export from qlikview where multiple XMLs have been loaded.

I will explain the issue.

1) I load several XMLs with thousands of lines

2) reload them into the table box

3) do some calculations and apply some limitations

4) Export to XLS (with the FILE >export > export contents  possibilitiy)

my problem is that when doing this way the qlikview (I suppose) sometimes mixes up the sources together and creates new lines of data, that are not anywhere in the original XML, nor in the loaded xml in the QV enviroment table box.

e.g. I upload XML1 with two atributes name and color (Andrew - RED) then I upload another XML2 with another set of data from the similar system, also in the same structure  with one line (Peter - BLUE). the exported result wil be three lines of data  (Andrew - RED + Peter - BLUE + Andrew -BLUE)

Does anybody have an idea why? I have originally suspected that the quality of XML is poor, but since the QV enviroment itself shows it correctly, my suspision is on the export procedure now.

Can anybdy helps?

many Thanks in advance

BR

Ondrej (QV beginner)

2 Replies
yura_ratu
Partner - Creator II
Partner - Creator II

Hi,

Looks like an issue in a script, during the data loading. Could you share an example?

Not applicable
Author

Hi Yurii,

Yes, I can share an example - see below.

but as I have written in the beginning, when I check the data in the QV environment it looks ok - based on my exaple, in QV environment there would be only two lines of data (Andrew - RED + Peter - BLUE) without any "mess".

But back to your reply here is my script (I do not adjust the script in any way manually, only automatically generated lines of code.

-------------

SET ThousandSep=' ';

SET DecimalSep=',';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep=',';

SET MoneyFormat='# ##0,00 Kč;-# ##0,00 Kč';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]';

SET MonthNames='1;2;3;4;5;6;7;8;9;10;11;12';

SET DayNames='po;út;st;čt;pá;so;ne';

// Start of [CostBuff_SVKKA_L2015_2015-10-19_085452.xml] LOAD statements

cost:

LOAD SAPType,

    SAPCode,

    CItem,

    cCena,

    CCUR,

    %Key_booking_BF7EB184D9F0F790    // Key to parent table: CostBuffXML/bookings/booking

FROM (XmlSimple, Table is [CostBuffXML/bookings/booking/costs/cost]);

booking:

LOAD BNR,

    RevenueTotal,

    DatumZadani,

    ExportdatumR,

    DatumOdjezdu,

    DatumNavratu,

    Country,

    %Key_CostBuffXML_D61D50334EA7495C,    // Key to parent table: CostBuffXML

    %Key_booking_BF7EB184D9F0F790    // Key for this table: CostBuffXML/bookings/booking

FROM (XmlSimple, Table is [CostBuffXML/bookings/booking]);

CostBuffXML:

LOAD Mandant,

    DB,

    CreaDate,

    CreaTime,

    %Key_CostBuffXML_D61D50334EA7495C    // Key for this table: CostBuffXML

FROM (XmlSimple, Table is [CostBuffXML]);

// End of [CostBuff_SVKKA_L2015_2015-10-19_085452.xml] LOAD statements

// Start of [CostBuff_CZEEX_L2015_2015-10-19_085912.xml] LOAD statements

cost:

LOAD SAPType,

    SAPCode,

    CItem,

    cCena,

    CCUR,

    %Key_booking_BF7EB184D9F0F790    // Key to parent table: CostBuffXML/bookings/booking

FROM (XmlSimple, Table is [CostBuffXML/bookings/booking/costs/cost]);

booking:

LOAD BNR,

    RevenueTotal,

    DatumZadani,

    ExportdatumR,

    DatumOdjezdu,

    DatumNavratu,

    Country,

    %Key_CostBuffXML_D61D50334EA7495C,    // Key to parent table: CostBuffXML

    %Key_booking_BF7EB184D9F0F790    // Key for this table: CostBuffXML/bookings/booking

FROM (XmlSimple, Table is [CostBuffXML/bookings/booking]);

CostBuffXML:

LOAD Mandant,

    DB,

    CreaDate,

    CreaTime,

    %Key_CostBuffXML_D61D50334EA7495C    // Key for this table: CostBuffXML

FROM (XmlSimple, Table is [CostBuffXML]);

// End of [CostBuff_CZEEX_L2015_2015-10-19_085912.xml] LOAD statements

--------

Thank you very much for your feedback and insight.

BR

Ondrej