topic Re: Difference in two simple ways of data loading (from qvd and excel) in QlikView

Difference in two simple ways of data loading (from qvd and excel)

Anonymous — Tue, 12 Dec 2017 07:55:08 GMT

Hello!

Problem:

I've got an excel file that I stored into QVD and I load some fields from there in the script attached below.

There are two ways of data loading with the difference only in 2 and 5 rows: loading from the qvd and from the excel.

The problem is I get different results.

When I try to count of "Ins" and "Outs" the first way give that count of "In" = count of "Out" (It doesn't correct), but the second one give a difference. How can I get the difference in calculation of count using loading from qvd? What's the difference in these ways?!

First way:

DataTemp:
Load 'In' as DataType, Field_1, Field_2, etc... from Data.QVD;
Concatenate(DataTemp)
Load 'Out' as DataType, Field_1, Field_2, etc... from Data.QVD;
NoConcatenate
DataTemp2:
Load
DataType, Field_1, Min (Field_2) as In
Resident DataTemp where DataType='In' Group by ...
Concatenate(DataTemp2)
Load
DataType, Field_1, Max (Field_2) as Out
Resident DataTemp where DataType='Out' Group by ...
Drop table DataTemp;

Second way:

DataTemp:
Load 'In' as DataType, Field_1, Field_2, etc... from Data.xlsx;
Concatenate(DataTemp)
Load 'Out' as DataType, Field_1, Field_2, etc... from Data.xlsx;
NoConcatenate
DataTemp2:
Load

... (the same script)

Best wishes,

Evgeniy

Re: Difference in two simple ways of data loading (from qvd and excel)

m_woolf — Tue, 12 Dec 2017 12:47:08 GMT

I don't see any difference in your load script, so I presume that the QVD contents differ from the Excel workbook.

Re: Difference in two simple ways of data loading (from qvd and excel)

Anonymous — Tue, 12 Dec 2017 13:09:16 GMT

But the QVD file is based on the same excel file that I use on my way.

My steps:

1. Load <All Fields> from Data.xlsx

2. Store loaded data into Data.qvd

3. Load <some fields> from Data.qvd

4. Concatenate load <some fields> from Data.qvd

etc. (script was described earlier)

But when I load directly from the Data.xlsx I get another result. Why?

Re: Difference in two simple ways of data loading (from qvd and excel)

m_woolf — Tue, 12 Dec 2017 13:30:07 GMT

Why don't you load all the data from the QVD and then do a send to Excel. You can compare that Excel with the other Excel to look for differences.

Can you share your data?

Re: Difference in two simple ways of data loading (from qvd and excel)

Anonymous — Wed, 13 Dec 2017 07:11:44 GMT

It was a really helpful advice! I checked qvd(s) and Excel data on a small part of the data and I found that a condition are missed.

I just needed to talk to an expert. Thanks a million!