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

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…?

image

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.

1 Like

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?

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.

1 Like

Hello @vignesh.ks,

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.