The result of the LEFT JOIN is correct.

Since you have multiple 03/11/2015 Date in Loads_By_Tran, it will return all matched records with FileDate in Loads.

Hi Rachel -

I think you are a victim of Joining table when you you want to blend tables - There is a link to a Webinar below that can take you through the blend process

I did not in your data that you joined on date - and that on there are multiple Transaction types - that is resulting in the multiples - the business question is are the
Loads" associated with a particular Trans type - if that is the case then you can blend by linking both data and trans type

Does that help any?

Jim

Advanced Live Training - Data Blending | Tableau Software

Thanks

I am a concerned that blending will not solve your problem either if the Load by trans  data applies to all the records in the Load file - is there anything else like load number that you can use to establish a 1 to 1 relationship between the record?

Jim

Your are welcome!