Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load data from two sources

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 ?

5 Replies
jsingh71
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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;

Not applicable
Author

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?