topic Upper Case File name in script file Path in QlikView

Upper Case File name in script file Path

poluvidyasagar — Sat, 16 Nov 2024 20:04:11 GMT

Hi,

I have an issue with my filename. For example,

Data:

Load * From Desktop/data.xlsx;

So the above way of loading works fine.

But if my file name is changed to DATA. Is there any I can change my file name in the script so that i can capitalize the file name in the file path so that it can work.

May be something like this:

Data:

Load * From Upper(Desktop/data.xlsx);

Please suggest.

Thanks,
Vidya

Re: Upper Case File name in script file Path

StarinieriG — Tue, 17 Sep 2019 15:56:54 GMT

Hi,

I am not sure, but maybe this could work:

IF Len(Trim(FileTime('Desktop/data.xlsx')))>0 then

Data:
LOAD *
FROM
[Desktop/data.xlsx];

else

Data:
LOAD *
FROM
[Desktop/DATA.xlsx];

END IF

Re: Upper Case File name in script file Path

Vegar — Tue, 17 Sep 2019 16:39:14 GMT

I normally do not get issues with file paths in upper or lower case, but if you do get an issue from the file name you could try to "loop" through the single file using file list.

for each _file in filelist ('c:\desktop\data.xlsx')

Load ...

From $(_file) ;

Re: Upper Case File name in script file Path

poluvidyasagar — Thu, 19 Sep 2019 19:05:52 GMT

Hi,

I have checked loading files with lowercase and uppercase file names. Both works fine.

I think Qlikview is insensitive to filename. It will read find even if the file name changes from lower to upper.

Thanks,

Vidya