Hello can i ask how can i link 2 columns together such that I can write out data based on 1 column reading.
@W_QW Consider dt as your datatable. Then use Following statement.
dt.Select(“[ID]=‘121212’”).CopyToDataTable
This will give datatable contains row which has ID as 121212
dt.Select(“[ID]=‘121212’”)(0)(1).ToString
Above statement gives value in Name column, If more then one row is present takes value m from first row
Can type out code in UIPath?
Why nothing come out
Why nothing come out?
@W_QW In the mentioned you are updating values in datatable only not in excel. For updating values in excel You have to write that datatable to excel again using write range activity(select header property) After For loop.
Do u mind typing out code according to excel?
I have to place it under Column (‘Name’)
How to link 2 columns tgt?