Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
miro_kopecky
New Contributor III

Outer Join 2 tables

Hello,
I have table_1 (PathMy, Word) and table_2 (PathMole, Word, WordCount, WordHex).
PathMy and PathMole have same values in rows, but Word are different.
I need Outer Join by PathMy, Word row from both tables but I cant figure out how to write this script.

If anyone could help me with this I would be very greatfull...
Thanks in advance.

Labels (4)
3 Replies
CarlosAMonroy
Contributor III

Re: Outer Join 2 tables

Hi Miro,

Did you try 'Concatenate' or Join? That way you will have values from both tables. But you have to be aware of how each of those append data.

Hope that helps,
Carlos M
miro_kopecky
New Contributor III

Re: Outer Join 2 tables

I didnt try that..but how do I write that script please?

CarlosAMonroy
Contributor III

Re: Outer Join 2 tables

Could be something like:

Table1:
Load
PathMy,
Word
From Table1;

Concatenate (Table1)

Table2:
Load
PathMole,
Word,
WordCount,
WordHex
From Table2;

That way you will have both values on 'Word' field. It all depends on the output you want to get.

Carlos M