Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic function to load all table

Hello All,

I have multiple table in a database:

ODCALL_2015_01

ODCALL_2015_02

ODCALL_2015_03

ODCALL_2015_04

ODCALL_2015_05

ODCALL_2015_06

ODCALL_2015_07

I need to load all of them in a single table.

I am trying create a variable but i cant get it right.

Any ideas?

Kind Regards,

Hasvine

3 Replies
Anonymous
Not applicable
Author

Just write this script?

Test:

Load

*

From ODCALL_2015_*;    //Start Star(*) which is wildchar in the end

It will load all the tables in one table Say Test

vikasmahajan

Hi,

https://community.qlik.com/thread/197094 ?

Please check if helped..

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.