Hi
I have an issue in filtering data table where I am trying to filter data table in Excel.
I am trying to remove rows containing negative values and giving the condition as below, but after filtering it is not giving me result without negative values.
[image]
I am trying to remove rows from a column if the cell values starts with “15” and gave the condition as below. Here as well, in the output, the result is not accurate and did not remove the required rows starting with “15”
[image]
Please see the reference data below.
[image]
The output data table contains negative values and contains rows starting with “15” as well.
Please let me know what I am doing wrong here because the filtering of data is not correct.
Attaching the Images , somehow didn’t got attach in first post
I am trying to remove rows containing negative values and giving the condition as below, but after filtering it is not giving me result without negative values.
I am trying to remove rows from a column if the cell values starts with “15” and gave the condition as below. Here as well, in the output, the result is not accurate and did not remove the required rows starting with “15”
I do use the same data table filter for some similar kind of operations, but it does not work here to remove negative values or values that start with “15”
if the filter result differs from expected output then we can shift to datatable.Select Method or to a LINQ statement. But referencing the columnname different will not fix.
Maybe you can share some sample data with us and we help you to setup an alternate filtering approach