Assigning an alias to a the values in a column (according to their ranking and partitioned by another column) in SQL (Snowflake)?

55 views Asked by At

Sample Data

I want to anonymize the locations and thus assign them a letter as an alias. So, 1 would correspond with A, 2 with B etc... It's already partitioned by vehicle, so locations can appear multiple times. Any idea how to do this on SQL (Snowflake)?

0

There are 0 answers