How to Generate New Table from 2 Table no key match

[Chanon_witt1]

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

[jonathandienst · Accepted solution]

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...)

[Chanon_witt1]

Thank you