Using if condition need to filter out and extract that filter data into another sheet in excel

Help Activities
, ,
2

Hi @ashwini_avula
welcome to forum

you can try this using linq query too

steps to be followed.

a. Read the excel and store in dt1 variable using read range.

b. build a datatable with required columns using build datatable activity and store in dt2

c . now use assign activity with below linq query

dt2 = (From row in dt1.AsEnumerable
Where CInt(row("Amount_Spend))>CInt(row(“Amount_Alloted”))
Let r1 = row.ItemArray
dt2.Rows.Add(r1)).CopyToDataTable

Try this way and let me know if it works

Regards,
Nived N
Happy Automation

1 Like