I need you help to to make this process quick

[Dmitri00007 (Dmitri)]

@Jobin_Joy

Please fine the attachment
01.xlsx (61.0 KB)

help me to get a linq method to do followings:

1. collect a one whole row of each invoice number (invoice number is repetitive)
2. sum the Incident Cost based on invoice number (=sum(L2:L85))
3. add a column and write same random number for all rows.
4. match report type with mapping sheet and replace it with system

I’m able to do it by uipath activities but its too time consuming, can you please write a linq query. please

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @Dmitri00007,

That’s a myth. Standard UiPath activities are not slow. Please read this thread from @postwick to know why.

There is no need to try to avoid For Each loops on large amounts of data

I’ve seen the discussion many times about avoiding For Each (Row) because looping through a lot of rows is inefficient. So I wrote a test. It creates a datatable of however many rows we want (Name, Age, City). Default values are Mary, 28, Dallas. Every 10th row is Tom, 27, Miami. Goal is to update Tom to Boston. [image] The first method is simply a single For Each with nested Assign to change Tom’s City to Boston. [image] This is the method of filtering into two separate DTs so you ha…

For your excel data, standard activities can be as fast at the linq query. My two cents.

[ynm_Sruthi]

Totally agree with @jeevith . I have seen this with huge volume of records as well.

Regards,
Sruthi YNM