Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load all files in directory but one

I want to load all files in a directory that have the same columns and the same name, but for the name of the month appended to the end. I also have a file in the same directory that has the same filename with "today" appended to the end of them.

MyFolder:

     xxxx_Aug.qvd

     xxxx_Apr.qvd

     xxxx_Oct.qvd

     xxxx_today.qvd

Can I load from all of them except the one the has 'today' at the end of it?

Thanks!

Tags (1)
1 Solution

Accepted Solutions

Re: Load all files in directory but one

Try it with:

Load * From Path\xxxx_???.qvd (qvd);

- Marcus

1 Reply

Re: Load all files in directory but one

Try it with:

Load * From Path\xxxx_???.qvd (qvd);

- Marcus

Community Browser