I'm trying to make a heatmap of "# occurrences" by state. The thing is, my data has both the abbreviation and full state name (both TX and Texas for example in the State column). When I try to edit aliases so "TX" aliases to Texas, it says 'cannot assign two members the same value (alias)'. My issue is, say there are 40 occurrences with "TX" and 40 with "Texas", I want the map to display "80" under Texas. I'd rather not VLOOKUP abbreviations into state names in the excel file, or write an IF statement with 50 conditions in Tableau.
Is there a simple way to do this?