Load multiple sql tabel

[ioanspy73]

hi there,

i have an ms sql database with the following tables:

trn2019, trn2020, trn2021 trn2022

all tables has the same structure and i want to load them on QlikView.

is there any way to load these tables via a for loop

thank you in advance

[Or]

You could achieve this using a For Each loop, see: https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptC...

However, if it's just those four tables, I wouldn't bother with a loop. Seems easier to just have four select statements.

[ioanspy73]

hi there

thank you for the reply.

i came up with this solution because i have to load table from 2016 and also each year will be a new one.