Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Valued Contributor

Re: load data from two sources

Can you explain in detail?

Re: load data from two sources

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

Re: load data from two sources

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

Re: load data from two sources

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.

Re: load data from two sources

Can you share a sample?