Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When the script displayed in the exhibit is reloaded, an error message is displayed.
Table not found
Left Join (SalesPerson)
LOAD ID,
DepartmentID
FROM [DataSourceA.xlsx]
(ooxml, embedded labels, table is SalesPersonDepartment);
What is the likely cause of the error?
A. When loaded, the SalesPerson table is auto concatenated to Customer and does not exist when referenced.
B. The Left Join statement fails to correctly bracket the referenced table name, such as Left Join ([SalesPerson]).
C. The Left Join statement fails to correctly quote the referenced table name, such as Left Join ("SalesPerson").
D. There is an error in the Customer table load and it is not created in memory.
I don't see Customer table in your script above, can you share the complete script?
In addition to Sunny's question: What do you get if you remove the Qualify statement and the Left Join statement?
HIC
Hi,
The answer is A.
A. When loaded, the SalesPerson table is auto concatenated to Customer and does not exist when referenced.
Even though the Customer table is missing from the screen print you included but I imagined that the Customer table is before the SalesPerson table.
I do not see a reference to customer table
try this:
SalesPerson:
NOCONCATENATE LOAD
...
Just this scrpt I have.
I did not understand why you are using QUALITY *; If you do a LEFT JOIN There has not been any connection. you should do UNQUALIFY to particular field that you want to connect with the tables or make CONCATENATE between tables It depends What exactly are you trying to achieve?