Run id per workflow run

[hima_shar]

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

[Inactive User · Accepted solution]

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],'-',''),' ',''),':',''))

[hima_shar]

thats perfect solution. Thank you very much.