Check whether file is refresh or not?

[rupaliqlik]

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‌

[eduardo_dimperio]

Maybe you could use

filetime() or QvdCreateTime(filename)

[kaushiknsolanki]

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

[its_anandrjs]

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