topic How to create variable data source in from in QlikView

How to create variable data source in from

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 22 Dec 2017 11:40:07 GMT

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

let vClient= 'B';

......

FROM

InputSheet_CLIENT$(vClient)*

;

Anonymous — Fri, 22 Dec 2017 11:43:53 GMT

Thanks! 😃