Hi,
I'm trying to set up an FME workspace so that the name of the output file at runtime is followed by the date the output file was generated.
For example: "myexcelfile_20210720", where "myexcelfile" is the prefixed name and "20210720" the current date.
How can I implement this with the FME Desktop Excel Writer?
Regards,
Hi @jiro
I suggest you to use the transformer DateTimeStamper to get the Date current.
On the Writer Excel, you can use the option Fanout attribute ( in navigator ) and concatenator the name:
Navigator configuration:
Thanks in Advance,
Danilo
Hi Danilo,
Thank you for your response. I'll give it a try try write away and I'll give you a feed-back.
Regards,
Hi Danilo,
Below is the Excel output file result. The file creation logic is fine but all the remaining columns are missing into the Excel file.
Thanks,
Hi Danilo,
Below is the Excel output file result. The file creation logic is fine but all the remaining columns are missing into the Excel file.
Thanks,
Hi.
Please, send me your Workspace template ( fmwt ).
Oh sorry Danilo! I had not seen the other columns in the Excel file which were hidden due to the size and width of the column. The workbench works very well ...
I'm just going to change the width of the columns in the Feature Type -> User Attribute.
Thank you again for your help! It's very appreciated.