LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Rename key inside of column

    Employee
    Posted 09-13-2017 07:17

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: abd.zoh

    Hello,

    I know that if you type "rename as " in the BrainScript you will rename the column name

    But how to rename the key inside the column? For instance rename Apr to April inside a BillingMonth column.

    Thank you in advance


  • 2.  RE: Rename key inside of column

    Employee
    Posted 09-13-2017 07:30

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    You don't "rename" data in a field, you replace it.


    s=BillingMonth.replace("Apr","April")
    emit *
    override emit s as BillingMonth