How to create variable data source in from

[Anonymous]

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

[t_chetirbok · Accepted solution]

usually you can just add the variable to the name of you file

let vClient= 'B';

......

FROM

InputSheet_CLIENT$(vClient)*

;

[Anonymous]

Thanks! 😃