unfortunately I have some problems understanding the “List of Files” and Iterations-Concept.
What do I need to achive:
I have a folder to which regularly I got an .xlsx file with a name like BLZ_YYYYMMDD.xlsx. The timestamp included in the filename is the validity from date of the file. I need to select always the latest file (highest date). With this file I need to perform a couple of transformations.
What I have done so far in EasyMorph:
I starteted in building up the needed transformations; first I selected the file to load manually > You will find als this in the “Main”-Module of the attached project.
Then I started to “develop” the list of file part in a second module “Load actual file”. Got all filters right so that always the latest file is residing in the list of files.
What does not work so far:
1) I could not get the iterations running. Keep getting an error that the parameter is empty/missing.
Note: Just by tipping this posting together and still fiddling around with the project I managed to get the iteration working; so everything marked in italics seems to be solved for now. Don`t know what I have done to get it working…
What is missing additionally:
2) I would need an YYMMDD string transformed from the file names timestamp from the Module “Load actual file” to include it in column “last_version” in the table “Ladeformat_BLZVZ” in Module “Main”.