Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ioanspy73
Contributor
Contributor

Load multiple sql tabel

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

Labels (1)
  • Other

2 Replies
Or
MVP
MVP

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
Contributor
Contributor
Author

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.