Count difference after loading data from Oracle

[rathnam_qv]

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.

[shraddha_g]

while loading field add rowno() using autogenerate and then see the max rowno

[zhadrakas]

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

[rathnam_qv]

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.

[jonathandienst · Accepted solution]

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.

[rathnam_qv]

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.

[jonathandienst]

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.