dynamic name in a from

[gr_eldred]

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]

You can use variable.

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

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

[sathishbabu_s_g]

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