Hello,
I have 3 tables basically.
Table 1 as below:
| Line# | No. | Country | Region | State | Location | Unit | LName | Feature1 | Feature2 | Feature3 | Feature4 | Feature5 | Feature6 | Feature7 | Measure | Quant | Measure1 | Estimate1 | Estimate2 |
|---|
This Table 1 is loaded from a single excel file no problem.
Now, Table 2 headers are as below:
| P.Name | Date | Name | Type | Model | Value | Currency | No. | LName | Vendor | Country | Region | State | Location | Unit | Type1 | Cat1 | Cat2 | Cat Type | Year | H1 | H2 |
|---|
This Table 2 is to be loaded from 5 excel files which have the same headers and format.
Table 3 headers are as below:
| PName | Date | Name | Type | Model | Value | Currency | LName | No. | Vendor | Country | Region | State | Location | Unit | Feature1 | Feature2 | Feature3 | Feature4 | Feature5 | Feature6 | Feature7 | Measure | H3 |
|---|
Again this table is to be loaded from another set of 5 excel files which have the same headers as above.
Now what I need to do is a Left Join of Table 2 and then Table 3 on Table 1.(Table 1 is Left).
What I have tried is as below:
Table 1:
Load *
FROM
[* Table1.xlsx]
(ooxml, embedded labels, table is XYZ);
Left Join
Table 2:
Load *
FROM
[*.xlsx]
(ooxml, embedded labels, table is ABC);
Left Join
Table 3:
Load *
FROM
[ *.xlsx]
(ooxml, embedded labels, table is DEF);
But I'm not getting the desired result as the join is not happening properly and most fields are being populated as blanks. Please help me achieve this. Thanks in advance!
