Row count is increasing like crazy

[#1]

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

[sundarakumar]

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

-Sundar

[#3 · Accepted solution]

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]

Show the Table Viewer screenshot here...

[nam]

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

[ashfaq_haseeb]

May be you have any cross joins.

If possible place script and datamodel

Regards

ASHFAQ