Renaming CSV files using variables

[#1]

Hello everyone,

I am working in a project where the database are CSV files and it is updated year by year.

The CSV name files are described as follow:

Report.xlsx

Report 2014.xlsx

Report 2015.xlsx

Report 2016.xlsx

I need QlikView LOAD all the files above and when the 2017 file is included in the folder, it will be automatically loaded.

I could easily use * in the name of the file, but i am loading my database from a web repository, so my FROM command is an URL and it is not possible to use * in the file name like that:

LOAD *

FROM

[http://la2.collaboration..com/team/20124c20/Documents/Report*.xlsx]

In that case, anyone could help me to solve that using variable?

Regards,

[#2]

Hi Rob,

I am trying to LOAD 2 tables from different tabs of the same spreadsheet.

Both LOAD statement was executed only one time.

Take a look the log attached.

Regards,

[rwunderlich]

Rodrigo,

It looks like you may have left out the NEXT keyword. Look back at Nicole's example to see that you need a NEXT statement to close the loop.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Or to do it bluntly maybe try a wildcard *

    LOAD *  FROM [LINK/Report*.xlsx] ; 

[#5]

You are right Bob!

I forgot the NEXT statement!

Thanks for the note!