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