Hi, if I concatenate 3 tables with the same KEY fields but deviating facts I have the following results:
Loading 10 lines:
After first table resutl is 10 lines
After second table result is 30 lines
After third table result is 70 lines
If I add an additional unique key per table this happens:
After first table resutl is 10 lines
After second table result is 20 lines
After third table result is 30 lines
I'm wondering if I get a doubling of my lines in the first method (and since I load millions of rows that is not preferable.
QlikView shows unique values only in table box but the table viewer does count 70 rows.
What is really happening under the hood, are there 70 lines that consumes resources? Thanks
