1 of 1 people found this helpful
It looks like you are on the right track! There are several ways you might do it, here's the way I might choose:
- Rename the Location and Postal Code fields because you will create new fields to replace them. I like to just put an underscore in front of them so I know what the original name was but it also indicates to me that they are only temporary and will be removed later. You might come up with a different convention. So, my fields are now _Location and _Postal Code
- Create new fields with calculations for Location and Postal Code. They will implement the logic you described above, but will retain the values present in the original _Location and _Postal Code fields if the location is not "CA"
- Group the CA value as HI for the Region field as you had previously done (you can actually just click on the CA value in the profile pane and type the new value)
- Remove the _Location and _Postal Code fields as they are no longer needed
Here are the order of Changes as they appear in Prep:
I've attached the flow so you can see it.
Hope that helps!
I wasn't clear in my initial ask, I was trying to rename the HI locations to the Port of LA in CA, but your logic and steps got me to what I needed! Thank you.