Skip to main content
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.