Efficient way to filter large data files

Help Activities
, , , , ,
2

I don’t know if it’s going to help you much, but there are two possibilities to handle large data files:

  1. Use C# or Python Code
    If you know C# it is possible through Invoke Code to write C# code in UiPath

  2. Use LINQ statements
    It is similar to SQL Queries, you can get started here:
    [HowTo] - Exploring the LINQ Universe (VB.Net)

  3. Process optimization
    “For each row” can be very time consuming, that’s why using LINQ statements is better.
    With the right statement you get the desired row and update the specific row by using the index.

Side note:
If you are running multiple robots you should divide your input file accordingly.