Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are getting the required output but the issue is when we add the Finance Category field in the filter pane we get an option to select Expense as well but it shouldn't be as per the logic. The reason we are getting this expense as an option to select in filter pane is because the logic works as per the Project Number level, as soon as we take Key as our linking field it creates the synthetic key as we can see pillar is based on the Project Number from project details table whereas finance category is based on Key field.
Note: So this Data quality table is completely built separately as we might have to add more rules in the future, so we cannot join this table with any other tables
Attached below is the sample data.
