How to Sort and Lookup Data Table in UiPath with .net DateTime - Full Tutorial

This video tutorial shows, how to use Sort DataTable to sort dates in a DataTablein UiPath, how to use Lookup DataTable and work with .net DateTime variables.

🔔Subscribe if you enjoyed

🤖UiPath - Work with Excel and DataTables

#uipath #rpa #tutorial

[andersjensenorg]

Fixing the Assembly Reference Problem:

[bjorn]

Thanks for very useful tutorial on sort and lookup data table.
I missed learning about the consequence if/when the data looked up doesn't appear. When looked up data is absent, the returned data is -1, but some basic tips on how to handle it (exception handling), maybe could be a future topic related to this video.

[rohantammewar]

Nice logic!
Can you provide a solution for following scenario:
Suppose we have a column with duplicate names, and user will provide name and the nth occurance of that name as input and provide the output as index of nth occurance of that name if exist, else print "name" has repeated n number of times.
Example 1:
Input: Anders
5
o/p: index of the name when it appeared for the fifth time in the column "Name"
Example 2:
Jensen
3
o/p:Jensen has repeated 2 times

[anandkumar-hcfw]

hi, Andrers, i followed your video, after Sort, ookup datatable
i am getting StrIndex is -1 .how can i fix it ?

[daxteoh]

your video learning has lots of coding, where should I start to learn the basic