what will you get by accessing the matadata info?????????????????
Actually how this idea came into your mind!
you want to tell the users the last modified time. Then simply do- Take a text object and write-last Modified date&'time(reload(time))'.. this will give a clear picture about the last reload time.
I now have a slight problem with this.
If I load from an .XLS file from a network folder everything works fine and I can see the Last Modified Date by using the FileTime() method.
However, my problem is that the .XLS file I am loading from is hosted in Sharepoint and is accessed via a URL (rather than a UNC path). In this scenario I am not getting any information back from FileTime(). I have tried two methods:
1) LOAD *, FileTime() AS LastModifiedTime FROM '<url>' (biff);
2) LET lastModifiedTime = FileTime('<url>');
Is this a known issue? Does anyone have any suggestions?