topic Re: Load files from folder in QlikView

Load files from folder

markgraham123 — Tue, 17 Oct 2017 15:19:48 GMT

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!

Re: Load files from folder

vkish16161 — Tue, 17 Oct 2017 15:32:49 GMT

You can try the FileBaseName() function.

Something like this:

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

Re: Load files from folder

vkish16161 — Tue, 17 Oct 2017 15:33:21 GMT

Is this Qlik Sense or View?

Re: Load files from folder

Anil_Babu_Samineni — Tue, 17 Oct 2017 15:37:02 GMT

May be this?

Sample:

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

NoConcatenate

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

DROP Table Sample;

Re: Load files from folder

markgraham123 — Tue, 17 Oct 2017 15:52:45 GMT

Anil,

I got all the file names i wanted.

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

Please advise!

Re: Load files from folder

Anil_Babu_Samineni — Tue, 17 Oct 2017 15:54:22 GMT

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

Re: Load files from folder

markgraham123 — Tue, 17 Oct 2017 15:55:38 GMT

yes.

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

But not working.

Re: Load files from folder

Anil_Babu_Samineni — Tue, 17 Oct 2017 15:56:55 GMT

What you have tried, please post script

Re: Load files from folder

markgraham123 — Tue, 17 Oct 2017 16:04:01 GMT

Sorry for the confusion.

"FileName" field has all the filenames i wanted.

Now, i wanted to load * from those files.

Re: Load files from folder

Anil_Babu_Samineni — Tue, 17 Oct 2017 16:07:18 GMT

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

Re: Load files from folder

markgraham123 — Tue, 17 Oct 2017 16:18:07 GMT

Got it! My mistake.

Thank you