I have a look up which has two filter conditions and then a derived column that has the condition isMatch() for all the output rows. Based on the derived column value, there is a conditional split. The Derived column is actually returning the value "False", whereas the expected value is "True".
So, I tried replacing the Lookup activity with Inner join and that is actually returning the correct row matching with the input. Can you please let me know why there is a discrepancy in these two activities or the Lookup activity is not working.