load data from two sources

[#1]

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 ?

[jsingh71]

Can you explain in detail?

[sunny_talwar]

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

[#4]

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;

[#5]

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.

[sunny_talwar]

Can you share a sample?