Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

dynamic name in a from

Hi,

I need to load tables with similar names, although the structure of the table name is the same changes in a few letters only.

gr_eldred_0-1589240172515.png

Load*from
[...2bapovZhdeB2BiEl5osztOliJHkdhra2NCIdEJ&listId=3db5105fa9&email=luis.castro%40multimedios.com&appID=](qvx);

se puede hacer así?

Can it be done like this?

Load*from
[...2bapovZhdeB2BiEl5osztOliJHkdhra2NCIdEJ&listId=3db5105fa9&email='%'&appID=](qvx);

Labels (2)
2 Replies
Highlighted
Specialist III
Specialist III

Re: dynamic name in a from

You can use variable.

Set vEmail= 'luis.castro%40multimedios.com';

Load * from
[...2bapovZhdeB2BiEl5osztOliJHkdhra2NCIdEJ&listId=3db5105fa9&email=$(vEmail)&appID=](qvx);
Highlighted
Contributor III
Contributor III

Re: dynamic name in a from

You can use both LET and SET function based way the table name changes.

 

If you think it's always same then define like 

Set tablename = 'luis.castro%40multimedios.com';

If you think it's dynamic and changes a bit then you can use Let function to defined it and  extract the table name string using  left and function