Run id per workflow run

Question

Hello All,

I have a column named 'Run_Id' and run_time  my target table. I need to populate these column with an unique number which will be per workflow.

For example - if workflow runs today ,  run id for all the columns should be 1 for all records. run id for next workflow run should be 2 for all the records and so on. Similarly run time should be start time ( date & time) of the workflow for all records.

Can you please suggest how to achieve this?

Thanks

Himanshu

unknown · Accepted Answer

For Run_Time, add a formula tool with Date & Time data type within the workflow stream and set it to:

DateTimeNow()

For Run_ID, I would once again use a formula tool but this time after the step above with  Integer 64 data type and set the formula as follows:

ToNumber(REPLACE(REPLACE(REPLACE([Run_Time],'-',''),' ',''),':',''))