Help understanding script

[#1]

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

[manojkulkarni · Accepted solution]

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]

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