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.
Solved! Go to 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 )
Legend! Thank you 🙂