Only Load Certain Tables

[kev6brown]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[kev6brown]

Perfect, thank you