topic Re: Change FileName while Loading in QlikView

Change FileName while Loading

Mon, 21 Dec 2015 07:53:17 GMT

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

PradeepReddy — Mon, 21 Dec 2015 07:59:50 GMT

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

ahbzshk07 — Mon, 21 Dec 2015 08:01:54 GMT

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

marcus_sommer — Mon, 21 Dec 2015 08:04:52 GMT

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 — Mon, 21 Dec 2015 08:07:15 GMT

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

Mon, 21 Dec 2015 08:17:14 GMT

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

PradeepReddy — Mon, 21 Dec 2015 09:07:57 GMT

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