Discussion Board for collaboration on QlikView Scripting.
I ahave a table with two coloumns
Val and Pub
if my values are
I need to load the data from Data_7.txt
if in case my values
I need to load the data from Data_0.txt
Usulally the Data_$(len).txt have to cotain the lenghth of the field PUB
My table will have always only one entry
Please suggest a way to achieve this
Go to Solution.
Something like this:
LOAD pub FROM ValPubSourceTable;
LET vLen = len(trim(peek('pub')));
LOAD * FROM Data_$(vLen).txt (txt, ....);