Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys
I have a table where the source is a database. However I have an excel file in the case where the data are not indicated to take them directly from the file and not from the database.
How do it pls ?
Can you explain in detail?
May be this:
Table:
LOAD *
FROM datasource;
Concatenate(Table)
LOAD *
FROM Excel
WHERE not Exist(ID);
Where ID is a unique field in the two tables.
HTH
Best,
Sunny
An exemple that i want to do
Table:
LOAD
A,
B,
C,
Year
FROM datasource;
if B is empty in 2015
LOAD
A,
B,
C,
Year
FROM
FROM Excel;
IThis is not what I want to do. If B is made in accordance empty key A , I'll go take B in the file to the same key A.
Can you share a sample?