Qlikview with multiple source XMLs export to XLS i... - Qlik Community

Report Inappropriate Content · ‎2015-10-21

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)

yura_ratu · ‎2015-10-21

Hi,

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

Report Inappropriate Content · ‎2015-10-22

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