Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use values in a field as a variable

Dear All,

I have fetch the all foldernames with a macro from the ftp site. The name of the field is fileName and the content of it as below:

08012012

08062012

08132012

08272012

09032012

09102012

09172012

09242012

Now I want to use them as a variable in the path instead of XXXXX.

LOAD

*

FROM

[ftp://username:password.ftp01.xyz.com/Koctas/Koctas_Logs/XXXXX/0001/asl.csv]

(txt, codepage is 1254, no labels, delimiter is ',', msq) ;

How can I do that?

Kind Regards,

1 Reply
Not applicable
Author

You can try this might work

Step1 :While Loading the table consisitng of File Index Numbers , also load along  with them the serial number using REC No() or RowNo() functions

Step2: Declare a Variable reffering to the path

Step3: Using For Next Loop and Peek Functions try to run