Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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