tag:blogger.com,1999:blog-5585680429157536914.post1912975247010470043..comments2023-12-19T01:06:46.450+00:00Comments on QlikView Addict: Checking if a File ExistsMatt Fryerhttp://www.blogger.com/profile/16375702764551893303noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5585680429157536914.post-74638393876898752682014-10-03T12:08:27.910+01:002014-10-03T12:08:27.910+01:00Can I user variable with the fucntions qvdCreatTim...Can I user variable with the fucntions qvdCreatTime() and filesize().<br /><br />The parameter fo rteh filenames would be something like sales$(vYear).txt ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-20485450658804948932013-09-24T14:27:40.640+01:002013-09-24T14:27:40.640+01:00To check for the existence of a folder you can do ...To check for the existence of a folder you can do this:<br /><br />if FileTime('C:\Test') > 0 then<br />Set vDirExists = 'Yes';<br />else<br />Set vDirExists = 'No';<br />end if<br /><br />Thanks to Rakesh Mehta!<br /><br />http://community.qlikview.com/thread/2715Anonymoushttps://www.blogger.com/profile/14525293377841133676noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-6604068716850377132012-12-07T11:10:04.121+00:002012-12-07T11:10:04.121+00:00Hi Richard
You'd need to use method 3 in the ...Hi Richard<br /><br />You'd need to use method 3 in the post above when using web tables.<br /><br />Regards<br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-46970947327984031322012-12-07T10:34:25.210+00:002012-12-07T10:34:25.210+00:00Would this method be applicable on a web table?
To...Would this method be applicable on a web table?<br />To se if a web table exists, then load the data from it?Richard Gullberghttps://www.blogger.com/profile/14862905956090371258noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-14920922221707236082012-02-23T22:43:13.520+00:002012-02-23T22:43:13.520+00:00Hi Ralf
Yup that would work too. I've also se...Hi Ralf<br /><br />Yup that would work too. I've also seen it done like this:<br /> <br />IF NOT isNull(fileSize('myfle.txt')) THEN<br />....<br />END IF<br /><br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-19687520655248957912012-02-23T22:25:27.434+00:002012-02-23T22:25:27.434+00:00Another way to check if a file exists:
IF len(Fil...Another way to check if a file exists:<br /><br />IF len(FileSize('myfile.txt')) > 0 THEN<br /> ....<br />END IF<br /><br />- RalfRalf Becherhttps://www.blogger.com/profile/15797897802954527219noreply@blogger.com