topic Re: dynamic loading files in QlikView

dynamic loading files

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to load these files dynamically?

EAST_SAL_2016.xls

EAST_COMM_2016.xls

WEST_SAL_2016.xls

WEST_COMM_2016.xls

NORTH_SAL_2016.xls

NORTH_COMM_2016.xls

SOUTH_SAL_2016.xls

SOUTH_COMM_2016.xls

Thanks in advance.

Re: dynamic loading files

Anonymous — Fri, 16 Sep 2016 02:18:19 GMT

What do you mean by dynamically?

If the file name changes, you can use wildcards to load them.

Re: dynamic loading files

Fri, 16 Sep 2016 02:27:18 GMT

I have used this script.

But I am looking for better way.

LOAD *,

FileName() as FileName

FROM

*.xlsx

(ooxml, embedded labels, table is [$(*)]);

Re: dynamic loading files

trdandamudi — Fri, 16 Sep 2016 03:00:17 GMT

The way you are loading is perfect and I don't think there is any better way. If you think I am missing the point can you explain with little more details...

Re: dynamic loading files

Anil_Babu_Samineni — Fri, 16 Sep 2016 03:01:11 GMT

I am not sure your question as I understand, you can load using qvd. Before that I've to ask one thing. In these files all field are same

Re: dynamic loading files

Digvijay_Singh — Fri, 16 Sep 2016 03:45:23 GMT

Are these file having same structure, are they auto concatenating sometimes and sometime not when new fields added? Do you need only one time load or require incremental load?

Re: dynamic loading files

Fri, 16 Sep 2016 04:13:55 GMT

SAL is one structure, COMM is different structured data.

Re: dynamic loading files

ToniKautto — Fri, 16 Sep 2016 04:43:46 GMT

If the files have different structure the answer to your questions depends on the difference in structure. Perhaps the data is suitable to force into same table, or perhaps it fit better in two (or more) tables. You will have to provide samples of the structure and your expectations to enable any detailed suggestion.

Re: dynamic loading files

marcus_sommer — Fri, 16 Sep 2016 05:22:40 GMT

A better way could be to load with a filelist-scan like: Dynamically Loading Multiple Excel Files.

- Marcus

Re: dynamic loading files

adamdavi3s — Fri, 16 Sep 2016 06:11:57 GMT

In this case I would use two loads in your loop in an if with a wildmatch to check the filename

So if it sees SAL it does load 1 to load fields x,y,z

if it sees COMM it does load 2 to load fields 1,2,3

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

Re: dynamic loading files

beck_bakytbek — Fri, 16 Sep 2016 10:28:57 GMT

Hi Jack,

check this Video: QlikView - Loading Data From Multiple Files - YouTube

i hope that helps

beck

Re: dynamic loading files

jagan — Mon, 24 Oct 2016 06:37:23 GMT

Hi,

Load the data with 2 load statements

Salary:

LOAD *,

FileName() as FileName,

FROM

*SAL*.xlsx

(ooxml, embedded labels, table is [$(*)]);

Commission:

LOAD *,

FileName() as FileName,

FROM

*COMM*.xlsx

(ooxml, embedded labels, table is [$(*)]);

Hope this helps you.

Regards,

jagan.