1. Concatenate 2 column

[vikram.g1 (Vikram G)]

Hi Experts,

I was trying to Concatenate 2 column(Ex: Column B and C) in an excel and paste the result in the 3rd column(Column A), and here i will be not knowing how many data will be present in the column, so please can any one suggest how can i handle this issue.

Thanks,
Vikram

[sumitd (Sumit)]

One way would be to read the excel range into a datatable and then use ‘For Each Row’ activity to iterate through the datatable. The ‘For Each Row’ will stop when there is no more data present in the column, so you will not need to worry about that.

[Srini84 (Srinivas)]

@vikram.g1

Use for each row and Assign a value as below

DT.Rows(index).Item("Total") = row("ID").ToString + row("NUM").ToString

For your reference check below
https://forum.uipath.com/t/tutorial-how-to-calculate-difference-between-two-time-values-using-uipath/247565/3

Mark as solution if this helps

Thanks

[vikram.g1 (Vikram G)]

Hi @Srini84 ,

I am getting some error while trying this, please can you give me one example.

Thanks,
Vikram

[Srini84 (Srinivas)]

@vikram.g1

Check as below

Attached workflow
Test-concanate.zip (22.4 KB)

Mark as solution if this helps

Thanks