I have data table as below:
I am providing condition to compare as below:
dt.select("[ID1] <> [ID2]")
My expectation: I need to get last 3 rows in output.
However, I am getting only last row in output.
i.e., if any of the column value is blank, it is considering as equal.