How to find column value is blank and update the status without using Loop

[nithya]

Hello All,

In this excel file ,The column (Current H8,New H8, Delivery Location)should not be empty, If this following column are empty, In status it should update as Unsuccessful & Remarks are Column name (Current H8,New H8, Delivery Location)not found.

Also New H8 <> Current H8, In status is Unsuccessful & Remarks as New H8 & Current H8 are same.

Finally, I need to add the values to queue where Status <> Unsuccessful.

Since, there are more than 15K rows, I need to process without using loop,
Excel, for your reference

Thanks in advance.

@prasath_S @Palaniyappan @NIVED_NAMBIAR @ppr

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

Hi @nithya,

Your request of not using loops for performance reasons is not correct. Please read this thread to know more about the two approaches: standard loops (which in the backend probably already use linq) vs. standalone linq query in UiPath.

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…

As per the approach you can use.
You can use a for loop or nested loops and build up all the logic to find where the edits need to be made and when an index matches those conditions, update the status column with the required string and later write it to excel.

[ppr (Peter Preuss)]

have a look here:
How to Update Data Column Values of a Data Table | Community Blog

Your case has a chance to get solved with a data column expression approach

[kadiravan_kalidoss (Kadiravan K)]

Hi @nithya,

Please try this approach, I have used excel as Database and updated the columns as per your requirement.

xaml:
ExcelUpdateRows.xaml (8.8 KB)

Sample Output:
Data.xlsx (12.5 KB)

Please change the Excel file path in argument and test it.

Thanks!

[nithya]

Hi @kadiravan_kalidoss ,

Thanks for your reply, I tried executing the bot with sample excel you have provided,
I am facing issue while execution,

Screenshot for reference.

[kadiravan_kalidoss (Kadiravan K)]

@nithya

Thanks for your reply, I tried executing the bot with sample excel you have provided,
I am facing issue while execution,

Hi @nithya,

For me its running fine, unable to reproduce your error. Can you please check file path and Non Execute query activity connection properties to ensure everything is in place.

Thanks!

[nithya]

I have changed the Excel path @kadiravan_kalidoss .
Do I need to give anything on parameter?

[kadiravan_kalidoss (Kadiravan K)]

Hi @nithya, everything looks good. Strange issue. Let me check and update you once i got the solution. Please let me know if you find anything.

[postwick (Paul)]

Just use a For Each loop. They aren’t slower than what you’re trying to do. It’s impossible not to loop, all you’re really doing here is trying to hide that it’s looping. 15k records is nothing. I did tests and had to get to 5 million rows before any noticeable processing time difference appeared.

[nithya]

@postwick ,Sure will try with for each loop to proceed further.

Thanks