Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
You can use variable.
Set vEmail= 'luis.castro%40multimedios.com';
Load * from
[...2bapovZhdeB2BiEl5osztOliJHkdhra2NCIdEJ&listId=3db5105fa9&email=$(vEmail)&appID=](qvx);
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