Adding FileName & Time Stamp to Column Header

Question

Hello, I'm working on a worfklow and this will be my last step before getting it complete.  This is for a workflow that is inside a batch macro which is making this tougher than I thought.  I need to create a column header that includes the input sheet name and the DateTimeNow() function combined.  I also need that column to be completely blank without any data except for the header itself.  I have the dynamic rename tool using the Rename using first row of data and then tried to delete the data using the select tool, but that is not working because the Column header is dynamic and changes whenever the file is started.  I have attached a picture showing the format of what I would need done, and if I can explain anything else please let me know.

Thanks

macst245 · Answer

@danilang Thanks for the response, however this will not work because I need the column header to be dynamic to match the input file name.  This is appending "Sheet ABC" to every excel sheet, when I need that name to be dynamic to match the input file names.

danilang · Answer

Hi @macst245

You can use this technique to append a timestamp column with blank values

The timestamp column input has one column with one dummy row.  After resizing it, build the column name including the timestamp.  Rename the column taking the name from the first row of data.  This results in a column with no values.  Append this column to your data.

You should be able to insert this technique in the macro.   If you want the files produced in the macro to have the same timestamp, use DateTimeStart() which returns the time the workflow started instead of DateTimeNow() .

Dan

NameAndTimeStampHeader.yxmd

macst245 · Answer

@JagdeeshN Yes, I have about 20 input files that I need run through the workflow one at a time so all the input sheets get the same processing.  I created a macro from this workflow and am running the macro in a separate workflow as shown below to finalize formatting and the output of the files.  I'm thinking the work I need for the column header done should be done inside the macro.