-
1. Re: Problem joining tables
Ahmad Hadzramin Abdul Rahman Jan 8, 2017 6:03 AM (in response to Rachel McGrane)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.
-
2. Re: Problem joining tables
Jim DehnerJan 8, 2017 5:57 AM (in response to Rachel McGrane)
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 typeDoes that help any?
Jim
-
3. Re: Problem joining tables
Rachel McGrane Jan 8, 2017 8:13 AM (in response to Jim Dehner)Hi Jim,
Thanks again - yes this helps - I haven't heard of blending yet - I will look this up. The Loads value is the sum of all the loads by transaction - it's a one liner, of the overall transactions.
Thanks for the help!
-
4. Re: Problem joining tables
Rachel McGrane Jan 8, 2017 8:13 AM (in response to Ahmad Hadzramin Abdul Rahman)Thank you very much, that makes sense.
Thanks for the help!
-
5. Re: Problem joining tables
Jim DehnerJan 8, 2017 8:26 AM (in response to Rachel McGrane)
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
-
6. Re: Problem joining tables
Ahmad Hadzramin Abdul Rahman Jan 9, 2017 2:33 AM (in response to Rachel McGrane)Your are welcome!