topic How check same text file name in folders in QlikView

How check same text file name in folders

Fri, 14 Nov 2014 10:33:21 GMT

Hi Friends,

I have files in folders structure like this

Data\Countries\USA\xxx.txt,

Data\Countries\UK\xxx.txt,

Data\Countires\Germany\xxx.txt.

Before getting the data I need to check wether the xxx file exists in the folders.

IF not I want to inform the user the country where the user dint place the text file.

Thanks

Gysbert_Wassenaar — Fri, 14 Nov 2014 10:36:12 GMT

You can use the filetime function to check for the existence of a file

if (filetime('Data\Countries\UK\xxx.txt')) then

... // file exists

else

... // file does not exist

endif

Fri, 14 Nov 2014 10:53:40 GMT

Thanks

Should I write seperate path each country??

Can I record all the paths where we don't have xxx file into a Table??

Thanks

Pavan

Gysbert_Wassenaar — Fri, 14 Nov 2014 11:04:49 GMT

If you have a table with countries you can use that. See attached example.

Fri, 14 Nov 2014 11:48:18 GMT

Great Thank So much