topic Re: Load if File already not Loaded in App Development

Load if File already not Loaded

Anonymous — Sun, 11 Mar 2018 11:57:59 GMT

Hi,

On a daily basis i have to load a File which contains several records. This file i keep in a Control Table. I would like to know how can i check if the file was already loaded, and if so, will not load the file contents.

I have the following:

/* records in table A may repeat */

[Table A]

Concatenate (Table A)

Load

codjogador,

name,

birthday,

deposit,

cashout

$(vFile) as FileName,

from [$vFile]

(XmlSimple, table is [ficheiro/registos_jogador/jogador]);

[TB_ETL_CONTROL]:

Concatenate (TB_ETL_CONTROL)

LOAD *,

Timestamp(Now(1),'YYYY/MM/DD hh:mm:ss') as ETL_TIMESTAMP,

ComputerName() as ETL_COMPUTER,

ClientPlatform() as ETL_PLATFORM,

DocumentName() as ETL_APP,

OSUser() as ETL_USER,

GetCollationLocale() as ETL_LOCALE

INLINE

[ETL_CTRL_PROC, ETL_FILENAME,

'ETL - JGDR' , '$(vFile)'];

What i would need to do is check if $(vFile) is already upoaded on TB_ETL_CONTROL and if not then upload it to TABLE A.

Thanks in Advance,

Francisco

Re: Load if File already not Loaded

isingh30 — Sun, 11 Mar 2018 17:41:47 GMT

Did you tried Exist function in the script?

Re: Load if File already not Loaded

Anonymous — Mon, 12 Mar 2018 11:07:05 GMT

Hi,

I tried with the Exist function but since [Table A] can have repeated records and since the filename will be in different records i can't use exist function.

My idea, is if there's a way to do something similar to:

if [Filename exists in TB_ETL_CONTROL] then

Load File

end if

Re: Load if File already not Loaded

isingh30 — Mon, 12 Mar 2018 13:03:54 GMT

http://www.qlikviewaddict.com/2012/02/checking-file-exists.html