topic Re: load data from two sources in QlikView

load data from two sources

Tue, 15 Sep 2015 10:47:36 GMT

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 ?

Re: load data from two sources

jsingh71 — Tue, 15 Sep 2015 10:50:54 GMT

Can you explain in detail?

Re: load data from two sources

sunny_talwar — Tue, 15 Sep 2015 10:51:06 GMT

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

Re: load data from two sources

Tue, 15 Sep 2015 11:02:49 GMT

An exemple that i want to do

Table:

LOAD

Year

FROM datasource;

if B is empty in 2015

LOAD

Year

FROM

FROM Excel;

Re: load data from two sources

Tue, 15 Sep 2015 11:04:11 GMT

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

sunny_talwar — Tue, 15 Sep 2015 12:16:30 GMT

Can you share a sample?