
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Understanding concatenate
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Michiel,
Can we have a fragment of data and your download code?
Regards,
Andrey

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Michiel,
You can't use the TableBox object to count your data in your data model. The TableBox object will show you only the distinct available values in your data model. Use the Table Viewer or a Chart object to count the actual data rows in your data model.
