March 15, 2023, 3:53am
I am trying to concatenate previous month/year in ‘MMM’YY’ format with exported excel filename , which extracted file from knime workflow . So something like -
"Population - Feb’23.xlsx "
Kindly let me know which node can used to get this done.
You can use a Create Date&Time Range node and set the number of rows to 1 and the start date&time to “current execution time”. Then you can use the Date&Time Shift node to subtract one month, followed by a Extract Date&Time Fields to get the year and the month. Now you can concatenate those using a String Manipulation node and create a file name using the Create File/Folder Variables node. This variable you create can then be used in the Excel Writer.
@rds you can take a look at these examples:
You could check this example out. Please note by default the Temp folder will be deleted after reset. You could also create a permanent folder or de-select the delete option.