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



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

use if condition


use add datarow
pass the value

place what activities you want in else part


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.


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


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



Already you are using build datatable

Add the columns in the build datatable which columns you want 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