HOW TO USE IF ELSE by column name

How to use if else condition by specifing column name.
if column name total is greater than 100 , another sheet should be created and store values(>100) in that sheet.
code for this please

@anjani_priya

Hi

before the process create a build datatable with columns which you want

use if condition

Cint(currentrow(“Columnname”).tostring)>100

then
use add datarow
pass the value

else
place what activities you want in else part

cheers

You don’t need to use Build Data Table if you’re reading data into the datatable from somewhere.

If you’re just trying to get all values where a particular column is over 100 then use Filter Datatable to generate a new datatable with the values you want. Then Write Range that new datatable to the sheet.

@postwick

the value need to return in another sheet

check the input once

here how can I create new data column and how to transfer the values to the new sheet which are >100

Hi

Hope the below steps would help you resolve this

  1. Use a assign activity and mention like this

int_sumvalue = DT.AsEnumerable.Sum(Function(a)Convert.ToDouble(a(“Column A”).ToString))

Where int_sumvalue is a variable of type integer

  1. With this u can use in. IF condition and perform on what u need whether to add a new sheet or anything

@anjani_priya

@anjani_priya

Already you are using build datatable

Add the columns in the build datatable which columns you want

3.in for each row in datatable

Take if activity if the condition matches then

Use add datarow and pass the values in that

task3.xaml (11.9 KB)
how to use if else here