topic Re: Check whether file is refresh or not? in QlikView

Check whether file is refresh or not?

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

Hello Experts,

I have one scenario where my user save one input file every day on one location and I have EDX trigger for my application.When file gets saved my application automatically reload and when it is not saved that day my application could not reload.But now I dont have EDX trigger for my application due to some reason so now how would my application come to know whether file is refreshed or not.?Because on that basis It should get save otherwise It will refreshed on old data when file is not update.

E.g

INPUT FILE.

PS_CASE_START.xlsx

stalwar1‌kaushik.solanki‌

Re: Check whether file is refresh or not?

eduardo_dimperio — Mon, 21 Aug 2017 20:40:41 GMT

Maybe you could use

filetime() or QvdCreateTime(filename)

Re: Check whether file is refresh or not?

kaushiknsolanki — Tue, 22 Aug 2017 05:58:55 GMT

Hi as eduardo.dimperio‌ suggested, you can file functions to know if file is there or not.

So the FileTIme() function can be used in this case. If file exists it will return the file time else it will return null.

Regards,

Kaushik Solanki

Re: Check whether file is refresh or not?

its_anandrjs — Tue, 22 Aug 2017 06:59:17 GMT

You can try this ways and other also suggest

TableName:

LOAD FileTime( ) as FileLastModify from PS_CASE_START.xlsx;

LET vModifyTime = Peek( 'FileLastModify', -1 , 'TableName' )

Regards

Anand