I have two datasources that unfortunately call the same thing two different names. One has the State as the two letter abbreviation and the other has it written out entirely. (i.e. CA vs California). I want to make the change on Tableau's end rather than the datasource as they're constantly being updated. My dataset joins on the order # instead of the state.
I could generate a hack to fix this but wanted to see if there was an elegant solution.