How get a column with timestamp value?

1、 read an EXCEL sheet into a datatable named dt1
2、add data column named “Key” in dt1 , i want to the “Key” colunmn value to be an sequence value, like 1,2,3,4,…
how can i do that?


1 Like
  • use assign activity like this keyValue =“key”+Counter.ToString
    use Add Data Row and add {KeyValue}
    and increment the Counter

Check this zip file workflow , @changzy (22.2 KB)
Hope this may help you :slight_smile: