Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am loading data from Oracle.
Actual Query Count is: 33009
Qlik also loading same count (33009) of records. But, i am finding different count (32348) after creating a Straight Table using those columns.
i am not able to find the issue?
can somebody let me know why it is behaving like this.
Thanks,
Muni.
The straight table will load distinct combinations of the dimensions. If you have more than one line with the same set of dimension value, the straight table will have less rows. You could create a unique key as outlined above.
while loading field add rowno() using autogenerate and then see the max rowno
Hello,
is the field your are using the Count on a keyfield?
if yes, try to duplicate this field with a new Name and Count this field.
regards
tim
Hi TIM,
Thanks for your Reply.
i checked the distinct count of key column it is matching with Database. But, overall count is not matching.
Thanks,
Muni.
The straight table will load distinct combinations of the dimensions. If you have more than one line with the same set of dimension value, the straight table will have less rows. You could create a unique key as outlined above.
Hi Jonathan,
Thanks for your valuable time.
i am using the following
AUTONUMBER(TEXT(PO_NBR & '|' & PART_NBR & '|' & QTY)) AS KEY
is this leading to have less records?
Thanks,
Muni.
That will have the same cardinality as the underlying values, so it will not add or remove any rows - providing the 3 underlying values are in the original table.