topic Load multiple sql tabel in QlikView

Load multiple sql tabel

ioanspy73 — Mon, 26 Jan 2026 16:26:21 GMT

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 — Tue, 20 Sep 2022 12:35:13 GMT

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

ioanspy73 — Tue, 20 Sep 2022 16:37:54 GMT

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.