Upper Case File name in script file Path

[poluvidyasagar]

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

[StarinieriG]

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

[Vegar]

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) ;

Next

[poluvidyasagar · Accepted solution]

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