Load files from folder

[markgraham123]

All,

I'm trying to only load files which have 9 am Timestamp.

I tried below code - but this did not help.

Load *

FROM

[..\TEST\*9 AM*.qvd]

(qvd);

Here is the example:

Demand Master 2017-09-05  8 AM

Demand Master 2017-09-05  9 AM

Demand Master 2017-09-05  10 AM

Demand Master 2017-09-05  11 AM

Demand Master 2017-09-06  8 AM

Demand Master 2017-09-06  9 AM

Demand Master 2017-09-06  10 AM

Demand Master 2017-09-06  11 AM

Any help is highly appreciated!

[vkish16161]

You can try the FileBaseName() function.

Something like this:

where Wildmatch(filebasename (lib://Insert your coneection path here),'*9 AM*')

[vkish16161]

Is this Qlik Sense or View?

[Anil_Babu_Samineni]

May be this?

Sample:

LOAD FileName() as FileName, SubField(FileName(), ' ', -2) as Field;

NoConcatenate

LOAD * Resident Sample Where Match(Field,9);

DROP Table Sample;

[markgraham123]

Anil,

I got all the file names i wanted.

how do i use that field now to load data from it.

Please advise!

[Anil_Babu_Samineni]

It's there in my code which fieldname called "Field"

[markgraham123]

yes.

I'm trying to use that "Field" in the from statement.

But not working.

[Anil_Babu_Samineni]

What you have tried, please post script

[markgraham123]

Sorry for the confusion.

"FileName" field has all the filenames i wanted.

Now, i wanted to load * from those files.

[Anil_Babu_Samineni · Accepted solution]

If you notice, I've created resident copy load from all filenames which you need to set up same thing? Highlighted 3 lines where you need to write code