topic Re: how to load multiple weekly files in script in Archived Groups

how to load multiple weekly files in script

yogitamehta10 — Tue, 22 Jul 2025 17:59:49 GMT

HI Everyone,

i have a doubt related to file structure.

I have a excel file i'm loading data from that file that file name has date embed in this .Book_22042016 , So i'm getting this file on weekly basis , like next file would be 29/04/2016 .

Every file has same type of data like in file we have item number , total 100 item number are there , these are fixed , no addition in that just the status of items are changing So my dashbaord should show the current week data and in another graph i will show last week and current week Progrees in status means i want to count stattus that is the progress.

how should i write my script so that it will capture all the weekly files and if i want i can show last week and current week data.

Re: how to load multiple weekly files in script

gardenierbi — Mon, 09 May 2016 11:44:55 GMT

Did you try this : https://community.qlik.com/search.jspa?q=load+weekly+files‌‌ ?

Re: how to load multiple weekly files in script

Gysbert_Wassenaar — Mon, 09 May 2016 11:49:46 GMT

Perhaps like this:

ExcelData:

LOAD

Date#(SubField(FileBaseName(),'_',-1),'DDMMYYYY') as FileDate

FROM

Book*.xslx (ooxml, embedded labels, table is Sheet1)

;

Re: how to load multiple weekly files in script

yogitamehta10 — Mon, 09 May 2016 12:01:59 GMT

but then how i will i load my file on weekly basis automatically

Re: how to load multiple weekly files in script

Gysbert_Wassenaar — Mon, 09 May 2016 12:11:06 GMT

Together with all the other data. You can use the FileDate field to distinguish between the weeks.

Re: how to load multiple weekly files in script

yogitamehta10 — Mon, 09 May 2016 12:12:21 GMT

week1 data

MAP_DATA_ITEM_NUM	MAP_DATA_ITEM_NAME	MAP_DATA_ITEM_DESCRIPTION
D2001	SPID	never started
D2001		start
D2001	SPID	open
D2001	SPID	developemnt
D2001	SPID	open

Week 2

MAP_DATA_ITEM_NUM	MAP_DATA_ITEM_NAME	MAP_DATA_ITEM_DESCRIPTION
D2001	SPID	start
D2001		in progress
D2001	SPID	close
D2001	SPID	developemnt in complete
D2001	SPID	in progress

so check the type of data i have , i have three columns item number is same everytime just the status is changing.

so i need to calculate howmany are in progree , open , close this week and last week .

i'm getting these type of files.

how should i write my script.

file name is like Book_28042016

Re: how to load multiple weekly files in script

yogitamehta10 — Mon, 09 May 2016 12:15:29 GMT

so everytime new file come , how can qlik view automatically will laod because file will be having differnt name as date will be changed while loading it will give me error

Re: how to load multiple weekly files in script

Gysbert_Wassenaar — Mon, 09 May 2016 12:17:26 GMT

Like this:

ExcelData:

LOAD

MAP_DATA_ITEM_NUM,

MAP_DATA_ITEM_NAME,

MAP_DATA_ITEM_DESCRIPTION,

Date#(SubField(FileBaseName(),'_',-1),'DDMMYYYY') as FileDate

FROM

Book*.xslx (ooxml, embedded labels, table is Sheet1)

;