topic dynamic name in a from in QlikView

dynamic name in a from

gr_eldred — Sat, 16 Nov 2024 00:41:50 GMT

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.

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);

Saravanan_Desingh — Wed, 13 May 2020 03:56:49 GMT

You can use variable.

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

sathishbabu_s_g — Wed, 13 May 2020 05:39:52 GMT

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