topic Re: Help need on Extracting data from database to QVDs in QlikView

Help need on Extracting data from database to QVDs

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

Hi Experts,

Can any one please help me on below Two requirements.

In my Data base Daily jobs will run like below.

When I have extracted the jobs from database to QVDs on today 17/02/18 I have to extract only from today to last 8 days jobs from data base to QVDs i.e., Total 9 QVDs

1. A180209_AJOB

2. A180210_AJOB

3. A180211_AJOB

4. A180212_AJOB

5. A180213_AJOB

6. A180214_AJOB

7. A180215_AJOB

8. A180216_AJOB

9. A180217_AJOB

When I have extracted the jobs on tomorrow 18/02/18 I have to extract only from today to last 8 days jobs from data base to QVDs i.e.,

Total 9 QVDs

1. A180210_AJOB

2. A180211_AJOB

3. A180212_AJOB

4. A180213_AJOB

5. A180214_AJOB

6. A180215_AJOB

7. A180216_AJOB

8. A180217_AJOB

9. A180218_AJOB

How to automate this process please help me on this

Thanks in advance.

Re: Help need on Extracting data from database to QVDs

shiveshsingh — Sun, 18 Feb 2018 15:47:34 GMT

What's the script that you are using?

You can put a filter to take only latest 9 values from max date.

Re: Help need on Extracting data from database to QVDs

markp201 — Sun, 18 Feb 2018 16:17:51 GMT

Since it is a set number of days, you can setup a FOR loop

Output:

FOR vDay = 1 to 8

ExtractDay=today() - vDay + 1

SELECT

FROM

"A" & ExtractDay & "_AJOB"

One qvd/day or one qvd/all days?

For tomorrow is yesterday's data rebuilt or do you append?