Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanon_witt1
Contributor
Contributor

How to Generate New Table from 2 Table no key match

 

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

Ask Qlikview.JPGAsk Qlikview_1.JPG

Labels (1)
1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Chanon_witt1
Contributor
Contributor
Author

Thank you