topic Re: Loading data from 2 different sources in QlikView

Loading data from 2 different sources

DipeshVadgama — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can we load data from 2 different sources ? I mean if 1st file is not available in sources path then load same data file from other path.

Example.

Load

From C:\xzy.csv OR D:\xzy.csv;

If we can then please give me some example.

sunny_talwar — Wed, 21 Mar 2018 10:18:06 GMT

May be use an if statement like this

If FileSize(C:\xzy.csv) > 0 THEN

Load

From C:\xzy.csv

ELSE

Load

From D:\xzy.csv

ENDIF

olivierrobin — Wed, 21 Mar 2018 10:18:25 GMT

hello

you can use the filesize / filename / fielpath functions to determine if a file exist or not and then load a 2nd one

example:

let file='filea'

if filesize(a)=0 then

let file='fileb'

end if

file_loaded:

load * from $(file)

Chanty4u — Wed, 21 Mar 2018 10:18:28 GMT

you need to create to connections then.

both should be on same server.