Dynamic Data Source

techvarun — Fri, 28 Nov 2014 10:07:21 GMT

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

Re: Dynamic Data Source

Gysbert_Wassenaar — Fri, 28 Nov 2014 10:31:12 GMT

Something like this:

LOAD pub FROM ValPubSourceTable;

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

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