Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Community,
Now I have to change my source for 50> tables per client, source shown below:
FROM [lib://LOADDATA/InputSheet_CLIENTA*]
change to:
FROM [lib://LOADDATA/InputSheet_CLIENTB*]
I would like tot create a variable source. Something like:
LET/SET CLIENT = 'A'
FROM [lib://LOADDATA/InputSheet_CLIENT*]
change to:
FROM [lib://LOADDATA/InputSheet_CLIENT*]
This is a brief preview of what i need.
Can anybody help me?
Thanks in advance!
Grtz. Pascal
usually you can just add the variable to the name of you file
let vClient= 'B';
......
FROM
InputSheet_CLIENT$(vClient)*
;
usually you can just add the variable to the name of you file
let vClient= 'B';
......
FROM
InputSheet_CLIENT$(vClient)*
;
Thanks! 😃