Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help understanding script

HI All

Can you please help me understand the following script please.

Table 1

LOAD

A,

B,
C

from ..qvd 1;

No concatenate

Table 2

LOAD distinct A resident Table 1

concatenate

A,

B,
C

from ..qvd2

Innerjoin (Table 1)

A,
1 as flag

from..qvd2

Left join(Table 1)

A,

1 as flag

resident Table1

What I understood is that 1st in Table1 we are loading fields A, B and C From qvd1 . Then in table2 we are loading the distinct values of field A from qvd1 . Then, by doing concatenate, we are combining A,B,C from qvd1 and qvd2. From there after, I am not able to understand the script.

My understanding of inner join is that if there is table a and table b: when we do inner join of table a with table b, we get only the common fields present in both tables. And, left join of table a with table b gives all fields from table a and only the common fields from table b.

But I am not understanding in the script above which table is having inner join with which table and same is the case with left join. Please help

Thanks

1 Solution

Accepted Solutions
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Innerjoin (Table 1) -- Making Inner join operation with Table1 using field A from QVD2

A,
1 as flag

from..qvd2

Left join(Table 1) -- doing left join to Table1 on field A

A,

1 as flag

resident Table1

View solution in original post

2 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Innerjoin (Table 1) -- Making Inner join operation with Table1 using field A from QVD2

A,
1 as flag

from..qvd2

Left join(Table 1) -- doing left join to Table1 on field A

A,

1 as flag

resident Table1

sorrakis01
Specialist
Specialist

Hi,

This script concatenate the 2 qvds + all distinct values of A for table 1, the joins in this case don't have utility... Maybe you can explain to the community what do you need... but i think that the structure of this script "is rarely".

Regards