topic Re: Only Load Certain Tables in QlikView

Only Load Certain Tables

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

Hi,

I was wondering how easy it was to only load certain tables in my script.

So, I have a number of tables called, Y1, Y2, Y3, Y4 etc, and variables set up for vY1, vY2, vY3, vY4 etc, which point to where the tables are sourced from. If i only want to run Y1 and Y2 can i do that using an input box in the dashboard? So, if vY1 = 'Yes' then run that table, if vY4 ='No' then don't run it

Kev

Re: Only Load Certain Tables

Gysbert_Wassenaar — Fri, 21 Dec 2018 09:14:42 GMT

You can use if-then statements in your script:

If vY1 = 'Yes' Then
    Y1:
    LOAD * FROM ...Y1 source table...;
End If

Create a block for each conditional load.

Re: Only Load Certain Tables

kev6brown — Fri, 21 Dec 2018 14:14:36 GMT

Perfect, thank you