Rename a field in a dimension

[Anonymous]

I need to change the name of a filed in a dimension within the data table. We have a list of user names associated with orders, but one user name is a person that is always associated with automated orders, so his name being in the list is inaccurate. For the dimension "Order - Created By Header", I want the name "Glazer, George" to be displayed as "Automated User" while all the other fields stay as they are. For example, below is the current way the data is displayed

Order - Created By Header
Glazer, George
Jones, Amy
Smith, Mike

But I want it to load this way

Order - Created By Header
Automated User
Jones, Amy
Smith, Mike

Thanks!

[rittermd]

I think if you created an expression something like this,

If (username='Glazer, George','Automated User',username)

[rittermd]

Or you could put something similar in your load script so that it is changed up front and then you can just display the field as your Dimension without any expression.

[Anonymous]

Thanks! How would that look in the load script?

[rittermd]

You could pretty much use the same logic but add an AS at the end and give the new field a name.  Then use that field name as your Dimension in your app.