How to filter data whcih i required

[T_Y_Raju]

can anyone help me how do i filter ₹ 0.00 ₹ 0.01 from excel i tried but not happening

filter data.xlsx (8.1 KB)

[pravallikapaluri]

Hi @T_Y_Raju

Hope it helps!!

[pravallikapaluri]

@T_Y_Raju

1fc6747e-c1b1-42f2-bc55-3c9add0e22ce.zip (49.4 KB)

[Nawazish_Ahmad]

Hi @T_Y_Raju

Try below steps:

1. Read Excel File and Check the PreserveFormat - Store in dt_Input as DataTable
2. Take Assign Activity & use below filter expression

---

dt_Input.AsEnumerable.Where(Function(x) x("Compare").ToString.Equals("₹ 0.01") OR x("Compare").ToString.Equals("₹ 0.00") ).CopyToDataTable

---

Hope it’ll helps you
Cheers!!

[T_Y_Raju]

this will remove data from the data table right .Actually my requirement is i want to apply filter on the data do some manipulation and unfilter the data …i want original data to be retrieved… i dont want to remove any of the data

[T_Y_Raju]

Actually the compare column data is in currency format

[sarvesh.b (Sarvesh)]

Hi @T_Y_Raju

See the below screenshots

Input Sheet

Output Sheet

Without writing the filter values in Sheet 2 you can do your manipulations it FilterDT variable itself.

Hope it helps,
Thanks!!