Join Data Sets Based on a Common Field

[Ishi_ta]

Hello Alteryx Community,

I'm trying to join two different data sets based on the name of the 'weather station'. Please see attachment below.

i.e. I want the latitude & longitude columns from data set 2 to be added as additional columns in data set 1.

When I try to use the join function - the inner join does not produce any results.

Any help would be appreciated.

Thanks.

[ramesh_neel · Accepted solution]

@Ishi_ta  - I see that the weather station column in your first data set contains spaces ( indicated by red color ) , so you need to remove them . This can be done using a Data Cleansing tool with the below setting. ( This has to be done before your join )

[Ishi_ta]

Legend! Thank you 🙂