Solved: Change FileName while Loading - Qlik Community

Report Inappropriate Content · ‎2015-12-21

Hi all,

For automation in Qlikview, first step i want to remove all timestamps from file while loading the first time while generating QVD.

Eg...I have a file say ABC_20121221.txt.

I want to trim this

LOAD *FROM ABC_20121221.TXT;

I just want Load * from ABC.txt;

Is there a way to do in qlikview?

Thanks

Khushboo

marcus_sommer · ‎2015-12-21

I think it's not a good idea to remove the timestamp from the filename and it's not necessary. You could load with a wildcard like:

LOAD * FROM ABC_*.TXT;

And if this not suits all requirements then you should load your data per filelist - see here an example: Loops in the Script.

- Marcus

PradeepReddy · ‎2015-12-21

Load * from subfield(filename,'_',1)&'.txt';

ahbzshk07 · ‎2015-12-21

do that only if that file exists at the relative path...

marcus_sommer · ‎2015-12-21

I think it's not a good idea to remove the timestamp from the filename and it's not necessary. You could load with a wildcard like:

LOAD * FROM ABC_*.TXT;

And if this not suits all requirements then you should load your data per filelist - see here an example: Loops in the Script.

- Marcus

Peter_Cammaert · ‎2015-12-21

Do you really need to rename those files? Can't you just ignore the timestamp (you'll be generating a qvd in any case) and load them all like this?

LOAD * FROM ABC*.Txt (options);

Report Inappropriate Content · ‎2015-12-21

this does not wok for me ... Does it work for you ... Can you post sample

PradeepReddy · ‎2015-12-21

It won't work.. its my overlooking..