Very useful...I have had many examples where people code up names of countries in different ways e.g. USA vs United States of America (although that might be a trickier issue to solve...) making spatial joins a bit of a nightmare
Yes true. For such cases, you'll just need to use do a substitution. I worked on a project where the input data would always come in with the names of weather stations would be spelt differently than what we had to join it with and I had a model that would just go through those and replace them. A CASE statement would work. CASE WHEN "name" = 'United States of America' THEN 'USA' WHEN "name" = 'United States' THEN 'USA' ... END
This just saved me so much time thankyou
Very useful...I have had many examples where people code up names of countries in different ways e.g. USA vs United States of America (although that might be a trickier issue to solve...) making spatial joins a bit of a nightmare
Yes true. For such cases, you'll just need to use do a substitution. I worked on a project where the input data would always come in with the names of weather stations would be spelt differently than what we had to join it with and I had a model that would just go through those and replace them. A CASE statement would work.
CASE
WHEN "name" = 'United States of America' THEN 'USA'
WHEN "name" = 'United States' THEN 'USA'
...
END
Wonderfull Wonderfull and really useful
Thank you! Cheers!