I have my target and actual in 2 different sources and I want to make report from these 2 DS.
Ex: In Primary Source Field is StoreLocation and Seconadry Source field is StoreCity and I'm unable to link to do analysis, but I'm able to to join the data id the fields names are same in both sources.
when blending the data Tableau automatically joins on the same names. If you want to join on different columns you have two options
1. Rename the source city from secondary to StoreLocation then Tableau connects automatically
2. Edit data relationship from data menu and define your custom join on Storelocation and StoreCity. Hope this helps.