For example i have below column in excel, and my Decision is to check if the column “Approved” has filled YES then proceed then its true which with proceed else its false and abort.
This decision only works with FALSEif the last row is NO.
But this one seems to be a logic miss out. You need to use Break in the else part as you intention is to abort the process once it reaches else condition.
Note If its not the scenario can you please elaborate more ?
@syed_Basha, If it could work for the last row why not middle ones ?
You can also check this,
Check for trailing spaces and case sensitivity and remove it before comparing. row("columnName").ToString.Trim.Equals("No", stringcomparison.InvariantCultureIgnoreCase)
Note Without seeing your code implementation it’s quite tough to debug. You can consider and proceed further.
The values are overwritten. If you have the values in the last row then probably there will be no values for over-writing. Thats why if you place the item in last row works always.
Scenario: Variable Agency_Name has found the match with your another excel. Since you haven’t used the break the values are overwritten. Kindly find the attachment FYR Maintest.xaml (23.7 KB)
Note (If you wish) You can also spare some time in UiPath Academy to have detailed idea about Datatables and also search our forum for more info.
I want to edit “excel-issue-when-applied-condition/26912/8” from the url and replace it with “UiPath-vs-automation-anywhere-blue-prism/5305” how can i do that.
All i did we capture the information of the url to a variable