Dynamic Data Source

[techvarun]

Hello Experts

   I ahave a table with two coloumns

Val and Pub

if my values are

Val            pub

1212121    1212121

I need to load the data from Data_7.txt

if in case my values

Val            pub

1212121   

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

[Gysbert_Wassenaar · Accepted solution]

Something like this:

LOAD pub FROM ValPubSourceTable;

LET vLen = len(trim(peek('pub')));

LOAD * FROM Data_$(vLen).txt (txt, ....);