I have a field (Customer Name) that I'm splitting with a calculated field into Last, First_Initial. However, one of the names was bad (instead of a "First Last" it is "First-Last").
My first thought was to just to alias that one name - changing the hyphen to a space. However, that doesn't appear to work. It's still splitting the dimension as if the alias isn't there. This confuses me, as I expected it to calculate on the alias, although I could understand why it doesn't default to that.
Questions:
- Is it correct that the calculated fields IGNORE the aliases?
- Is there a way to calculate based off of aliases?
I'm just doing a training module, and this particular step isn't part of the module (typo in data source). I know, technically, it would be best to just edit the data source. But is there a better way to handle this, say if I couldn't edit the data?
to the best of my information, alias does not get referred to in calculations.
Alternatively how about creating a calculated field which checks for that particular value and substitutes it to one that is desired. So it would look something like :
ALIASED_NAME
if [Customer Name] = 'First-Last' then 'First_last'
else [Customer Name]
And used ALIASED_NAME calc everywhere instead of Customer_Name
Will this work ?
