Looping Around a List of Files to Perform a Transformation of the File Data

This is a rather silly question but have you actually saved the transformation before running it from the package?

Also, watch this video

www.etl-tools.com/advanced-etl-processor...-mapped-problem.html

Doble click on all objects between reader and writer make sure that all of them are mapped

Hi Peter,

Thanks for the response.
Yes the transformer was saved.

I watched the video you provided the link for and used the Auto Map feature. Originally I had mapped this individually manually.
Upon re-mapping the fields with the Auto Map, this then subsequently processed the files.

Therefore achieving the main principle of what I'm trying to do.

Thanks so much for your help.
Ian

Hi Peter,

The only question I have left is, when I loop through these files which currently get written to one file, how would I get the writer, to write out the files to the destination, as their original filenames? (eg. 10 input files, they go through the transform, then 10 files with the same name go into the destination directory?

Many thanks,
Ian

There are multiple ways of doing it

For example, you can use calculations inside file names
Default repository has examples called Dynamic file names.


Or you can use calculations as described here
www.etl-tools.com/automation/0016-dynami...-on-field-value.html