Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview user
I want to Generate New Table DD from Table AA * Table BB * Table CC .
What should I do ?
Please Attach file Example
Thank you
If you join the tables (default outer join) when there is no key field between the two, then the join will create a Cartesian join. So you probably need something like this pattern:
Data:
LOAD * FROM AA.qvd (qvd);
JOIN (Data)
LOAD * FROM BB.qvd (qvd);
JOIN (Data)
LOAD * FROM CC.qvd (qvd);
Adjust the load sources to the correct source (name, extension if file, file quaifier...)
If you join the tables (default outer join) when there is no key field between the two, then the join will create a Cartesian join. So you probably need something like this pattern:
Data:
LOAD * FROM AA.qvd (qvd);
JOIN (Data)
LOAD * FROM BB.qvd (qvd);
JOIN (Data)
LOAD * FROM CC.qvd (qvd);
Adjust the load sources to the correct source (name, extension if file, file quaifier...)
Thank you