ETL and Data Integration tools - Modern ETL software for everyone

Good day

Can you please tell me if it is possible to rename a file using file operation and to then add System date or file date to the name. E.g. Take a ZIP file, UnZip, Change name from detail.zip to detail 20061020.zip?

I am using Vimp Pro at the moment, if it can't be done is it planned? I currently have to use another application for this function...

Please advise

Regards

Pieter

Documentation is the answer

You can use calculations in file names

Page 92

GETSYSTEMVARIABLE('SYSTEM_DATE') will return current date in ‘YYYYMMDDHHNNSS’ format

If we want only part of date we can use LeftString(String,Count):String for example

LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8) will return only date part.

Now more complicated example for loading yesterday’s data;

LeftString(DecDateS(GETSYSTEMVARIABLE('SYSTEM_DATE'),'YYYYMMDDHHNNSS', 'DAY',1),8)