How to compare a column value greater than 8.5 using if condition in ui path

Help Studio
, ,
1

how to compare a column value greater than 8.5 using if condition in ui path

2

@poojaskyrathore

  1. Read Range activity to read the excel file and give a Variable to the Datatable which is in properties

  2. Use For Each Row activity and give the variable which you give the variable in the Read Range activity

  3. Use IF condition inside the For Each row and write in IF condition as below
    Cdbl(Row(“ColumnName”).ToString) > 8.5

  4. If it is true place your logic in then or if it false place your logic in Else

Hope this may help you

Thanks

3

i want to apply this logic only for one column

4

@poojaskyrathore

Yes, you are checking for only one column only using the above steps

One Column and multiple rows correct?

Thanks

5

yes ,but above logic is not working

6

@poojaskyrathore

May I know what’s the issue you are facing?

thanks

7

complier error encountered processing expression cou(row(“Tot. Dur.”).ToString)>8.5

operation strict on disallows implicit conversion from string to integer

8

@poojaskyrathore

What is that cou?

It should be CDbl(row(“Tot. Dur.”).ToString) > 8.5

Hope this may help you

Thanks