Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to filter on files to read in a network/disc.

Hi!

In my script I only want to read the files that ends with AVA. How can I solve this? Thanks.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Use a wildcard.

Load *

From YourFolder\*AVA.xlsx;

View solution in original post

11 Replies
Anonymous
Not applicable
Author

Use a wildcard.

Load *

From YourFolder\*AVA.xlsx;

Anil_Babu_Samineni

Simple load *youstring ??

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MarcoWedel

another solution (having performance disadvantages because all files are loaded prior to filtering) but enabling other string operations on the filename also:

LOAD *

FROM *.xls

Where FileBaseName() like '*AVA';

hope this helps

regards

Marco

Anonymous
Not applicable
Author

I can't get it to work 😕 This is my script and I get the following error messages.

Tab1

Tab2

Anonymous
Not applicable
Author

Remove the comma after [SEL0004]

That doesn't belong.  That's why you're getting the red squiggly underlining.  And the other errors.

Anonymous
Not applicable
Author

I still get the red underline and errors after removing the comma.

Anonymous
Not applicable
Author

Oh you also need a comma after the *

So

Load *,

     DATE,

     [Branch Number],

     [SEL0004]

MarcoWedel

... and the semicolon between  .xls and where ...

So basically create a working LOAD statement first (e.g. using the file load wizard) and apply the "*" or "where" solution afterwards.

hope this helps

regards

Marco

Anonymous
Not applicable
Author

Hi,

It still doesn't work and the end of the last row is red so something is wrong there. Do you see what it is?