How to find specific value on Column A and copy the data on Column C

[Printf7]

Hello,

I would like to find ‘3/5/2021’ on Column A and then copy the value on same row on Column C.

Could you please let me know how to do it…?

[vignesh.ks]

Hi @Printf7

You can try this,

1.Create new variable with datatable type.
2.DataTable.select(“[Column Name]=‘searching value’”).copytodatatable.
3.After that, newDataTable.rows(0)(Column Name).ToString.

Thanks.

[Printf7]

Thank you for your answer!

I’m sorry that I’m beginner of UiPath. Could you please let me know how to do below?
2.DataTable.select(“[Column Name]=‘searching value’”).copytodatatable.
3.After that, newDataTable.rows(0)(Column Name).ToString.

and If there is no ‘Column Name’ on Excel file, Is there other way?

[vignesh.ks]

Hi @Printf7

Yes, you can use index of the column. I have attached the screen shots below for your reference.

Note: The variable type of ‘newDataTable’ is DataTable. And ‘columnCValue’ is string.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation.

[Printf7]

Hello @vignesh.ks,

Wow It works well.
I really appreciate about your help!