topic How to Generate New Table from 2 Table no key match in QlikView

How to Generate New Table from 2 Table no key match

Chanon_witt1 — Sat, 16 Nov 2024 01:28:35 GMT

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

Re: How to Generate New Table from 2 Table no key match

jonathandienst — Mon, 20 Jan 2020 07:40:26 GMT

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

Re: How to Generate New Table from 2 Table no key match

Chanon_witt1 — Mon, 20 Jan 2020 09:32:30 GMT

Thank you