topic Re: Load multiple qvd's in QlikView

Load multiple qvd's

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi team,

In daily basis this qvd's are generated.

The scenario i am facing is how bring all these qvd's into single block in script.( using For loop)

And how to identity only Mondays present in the qvd's and load them in script.

Please give your suggestions

Regards

Ashok ravichandran

Re: Load multiple qvd's

groveliam — Thu, 12 Jul 2018 18:40:53 GMT

Hey,

For the Load Script it is pretty easy once you know how to do it. You can pretty much do Load * From PATH/ABCD_fact*.qvd and this will load all your qvds in. If you want only Mondays, you can make a date variable like:

let a = 0;

let vDate = Date(Today() - a, 'MMDDYYYY');

a will be the counter for your loop and for your days.

Lets say you only want the last 60 days of Mondays:

let a = 0;

let vDate = Date(Today() - a, 'MMDDYYYY');

Do while (a < 60)

if(num(weekday(vDate) = 0) then

Load * From PATH/ABCD_fact$(vDate).qvd;

end if

let a = a + 1;

let vDate = Date(Today() - a, 'MMDDYYYY');

Loop

Now this is just an example so you will probably have to adjust some things (e.g. PATH should be changed to the correct path).

Let me know how that goes.

Re: Load multiple qvd's

groveliam — Thu, 12 Jul 2018 18:44:19 GMT

Also if you experience an error that stops the loop, just put the following statement above the do while line:

let ErrorMode = 0;

It will still look like there is an error, but that just means there is no file associated with that name and it will skip it.

Re: Load multiple qvd's

el_aprendiz111 — Thu, 12 Jul 2018 21:20:37 GMT

Hi,

TMP:
LOAD *,
DATE(date#(KeepChar(FileName(),'0123456789'),'MMDDYYYY'),'MM/DD/YYYY') as dateFile
FROM [..\H\qvdFolder\*.qvd] (qvd);

SUM:
LOAD *, WeekDay(dateFile) AS DayNam Resident TMP
Where NUM(WeekDay(dateFile))=0
;

DROP Table TMP;

**********

0 for Monday
1 for Tuesday
2 for Wednesday
3 for Thursday
4 for Friday
5 for Saturday
6 for Sunday

Re: Load multiple qvd's

qlikviewwizard — Fri, 13 Jul 2018 01:51:39 GMT

Hi Ashok Ravichandran,

Hereis the solution.

Data:

LOAD ID,

DATE,

SALES,

FileName() as FileName

FROM

(qvd)

WHERE WEEKDAY(DATE(DATE#(MID(FileName(),10,8),'DDMMYYYY'))) ='Mon';

Re: Load multiple qvd's

Anonymous — Fri, 13 Jul 2018 07:36:36 GMT

Liam,

Thanks for your suggestion, let me work it out and get back to you!!

Re: Load multiple qvd's

Anonymous — Fri, 13 Jul 2018 07:38:36 GMT

Arjun Bro,

Once again thanks for your suggestion,Let me work it out and get back to you!!

Re: Load multiple qvd's

qlikviewwizard — Fri, 13 Jul 2018 07:40:32 GMT

Hi ashok_ravichandran

Please check and mark the Correct Answer and close the tread. Thank you.

Re: Load multiple qvd's

Anonymous — Fri, 13 Jul 2018 11:15:32 GMT

It Worked thanks Arjun