I have reattached your workbook with what I think is the desired outcome. Look at Sheet5. Click on one of the Codes and it will filter the All_Codes worksheet. To do this, a couple things needed to be done. First, more relationships needed to be made between the data sources. To see which ones were added, go to Data-->Edit Relationships.
Then, a filter action was added to Sheet5 and was directed at the All_Codes worksheet; a specific field was added to filter on Code. I hope this helps!
Sample_Data.twbx.zip 88.5 KB
What I am trying to do is based on the filtered code in "Specific Code", let us say 1569.31, I want to see all the records with all codes that happened on the same date and Id combinations.
So if I filter for 1569.31, then I should see all codes for the Id and date associated with the 2 records that pop up, i.e. Id=X1 and dates= 1/14 and 2/24. With the blending I want to pull in the before_time and after_time columns for the 1569.31 records into the "All_codes" table.
Attached is an excel workbook of how I want this to look like. The records in Sheet 1 with "Final_selection"=Y are the records I need. Hope it makes more sense.
Sample _data.xlsx 40.4 KB