Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Dynamic function to load all table

balrajahlawat
Esteemed Contributor

Re: Dynamic function to load all table

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
Honored Contributor III

Re: Dynamic function to load all table

Hi,

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

Please check if helped..

Thanks

Vikas

Community Browser