Difference in two simple ways of data loading (from qvd and excel)
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?!
Load 'In' as DataType, Field_1, Field_2, etc... from Data.QVD;
Load 'Out' as DataType, Field_1, Field_2, etc... from Data.QVD;
DataType, Field_1, Min (Field_2) as In
Resident DataTemp where DataType='In' Group by ...
DataType, Field_1, Max (Field_2) as Out
Resident DataTemp where DataType='Out'Group by ...
Drop table DataTemp;
Load 'In' as DataType, Field_1, Field_2, etc... from Data.xlsx;
Load 'Out' as DataType, Field_1, Field_2, etc... from Data.xlsx;