Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Row count is increasing like crazy

Hello Everyone,

I have one qvd i am getting 700000 row count when i run that qvd alone.

when i included that in the Data Model, the row count is going like anything, it is going till 50000000, like that.

Any suggestion what would be the reason.

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

It seems like the Key on which you are joining it with Data Model is not just enough to uniquely represent a row.

I believe, the rows are getting multiplied due to duplicates in it.

to verify this, create a list box of the Key field and check its frequency.

Use AutonumberHash256(Field1,Field2,Field3) as FinalKey

Thanks,

Angad

View solution in original post

5 Replies
sundarakumar
Specialist II
Specialist II

Cartesian Product. One of ur join statement is the issue. Try reloading table by table. u can sort out the issue.

-Sundar

Not applicable
Author

It seems like the Key on which you are joining it with Data Model is not just enough to uniquely represent a row.

I believe, the rows are getting multiplied due to duplicates in it.

to verify this, create a list box of the Key field and check its frequency.

Use AutonumberHash256(Field1,Field2,Field3) as FinalKey

Thanks,

Angad

MK_QSL
MVP
MVP

Show the Table Viewer screenshot here...

nam
Former Employee
Former Employee

Please check your Keys, the Key may not be matching so its replicating against every Key

ashfaq_haseeb
Champion III
Champion III

May be you have any cross joins.

If possible place script and datamodel

Regards

ASHFAQ