Joining on multiple conditions

Question

My data is as seen below:

Data Source 1:

AccountCountryCode10021854156Spain1010151562

Spain

103012561864545132UK1020526526346513UK10305262563Italy10308989856456Italy1010

Data source 2:

CountryCodeTotal CostSpain1010100UK

102050Italy1030220Spain1020400UK1030520Spain103036Italy1010225

I would like to pull in the total cost from data source 2 into data source one but for the right code and the right country (2 conditions).

I have used a simply join with code and then country but it is not assigning the right country for some reason.

Please could someone assist?

cjaneczko · Accepted Answer

One way to do this is create a field that concatenates the Country and Code. Use a formula tool

[Country] + [Code]

Insert this into both Data sources and join on that. Uncheck it after the join so it doesnt display in the final results.

The other is to add the second condition to the join. Make sure the Data types in both data sets are the same. If for some reason the Code is Double in one of them and String in the other, it wont join properly.