Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

1 Solution

Accepted Solutions
marcus_sommer

Try it with:

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

- Marcus

View solution in original post

1 Reply
marcus_sommer

Try it with:

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

- Marcus