topic Count difference after loading data from Oracle in App Development

Count difference after loading data from Oracle

rathnam_qv — Wed, 09 Nov 2016 07:05:52 GMT

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.

Re: Count difference after loading data from Oracle

shraddha_g — Wed, 09 Nov 2016 07:10:22 GMT

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

Re: Count difference after loading data from Oracle

zhadrakas — Wed, 09 Nov 2016 07:11:22 GMT

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

Re: Count difference after loading data from Oracle

rathnam_qv — Wed, 09 Nov 2016 07:21:50 GMT

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.

Re: Count difference after loading data from Oracle

jonathandienst — Wed, 09 Nov 2016 07:21:56 GMT

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.

Re: Count difference after loading data from Oracle

rathnam_qv — Wed, 09 Nov 2016 07:27:11 GMT

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.

Re: Count difference after loading data from Oracle

jonathandienst — Thu, 10 Nov 2016 11:30:10 GMT

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.