I have created the dataset that you have provided and created the view on Tableau as attached. Hope this helps.
Can you tell us what issues you were facing so that we can try and identify the cause?
Thanks for the workbook.
Looking at it helped me figure out the problem. I was doing everything right except for one thing. I was trying to link a Calculated field in the Primary connection with a field in the secondary connection.
It seems you cannot link calculated fields. Because when i removed the calculated field and altered the format instead in my query and then applied the link it worked.