Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to combine two different QVD's based on some condition. that is dim_account1.account_key=dim_account2.account_key
but it is giving wrong results when compare to data base.
below is my logic in qlikview. If i Do inner join it gives me 0 records, because in both the tables there are almost 23 columns are common
Combine:
LOAD * From dim_account1.QVD(qvd);
Right Join(Combine)
LOAD * From dim_account2.QVD(qvd);
STORE Combine into path/dim_account.QVD(qvd);
DROP Table Combine;
Please help me on this issue
Regards,
Kumar
In two tables almost 120 columns are there.
Any how thanks Kush