Your workbook uses an extract so we can't get to the Data Source screen in order to play with the joins. Can you attach the sources or re-package without an extract? I think I may have an idea how to do this.
Hi Ken, really appreciate the reply. I've reattached the workbook and provided the dataset itself which is the example above...I apologize for the simplicity. I can try and create a more in-depth example if needed!
Join just based on Material.
This will give you something like this:
Then create a calculated field like this:
IF ISNULL([Plant (Contract Data)]) = TRUE OR [Plant (Contract Data)]=[Plant] THEN
Then simply filter your view, only selecting "Keep" records.
I think that should give you what you need. See attached workbook.
Material Contract Join.twbx 17.8 KB
That's exactly what I need to do, then I can use it as a datasource filter and eventually an extract filter before uploading to the server. I've been too narrowly focused on a solution using joins. Really appreciate the help!
No problem. Any time!