How can I change the name of columns

Loan_Nguyen56Loan_Nguyen56 Member Posts: 8 Contributor II
Hello All,

I would like to change the three last column's names into "First Class", "Second Class", and "Third Class" instead of "Passenger First Class"... as well.

Thank you very much.
Loan Nguyen

Best Answer

  • ceaperezceaperez Member Posts: 473 Unicorn
    Solution Accepted
    Hi @Loan_Nguyen56
    You have an operator named Rename into Blending-> Attributes->Names & Roles.



  • Loan_Nguyen56Loan_Nguyen56 Member Posts: 8 Contributor II
    edited April 2021
    Thanks for your letting me know. 
    Besides that, I follow the instructions below to get the new column names however, I cannot get the right answer. 
    Renaming attributes with regular expressions
    1. Search for the operator Rename by Replacing, add it, and connect it to Pivot.
    2. Also connect the operator to the result port on the right.
    3. Copy count\((.*)\)_(.*) into the replace what parameter field. Make sure that you get all the parentheses right!
    4. Copy $1 $2 into the replace by parameter. "
    And, what does count\((.*)\)_(.*)  means?


  • ceaperezceaperez Member Posts: 473 Unicorn
    Hi @Loan_Nguyen56

    They are replacing the names of the Attributes (Column) using a Regular Expression.
    Probably their Attributes names are like count(something)_anotherthing
    With this part count\((.*)\)_(.*) they are locating the two parametrized blocks after the string "count"
    Then with  $1 $2 instruction into the replace by parameter, they are replacing the original string by the first coincident block $1 (something) and the second coincidente block $2 (anotherthing)

    you don't have a regular pattern  in your Attributes names maybe is better to use another operator like Rename by Generic Name and write Passenger Class, for example. 

  • Loan_Nguyen56Loan_Nguyen56 Member Posts: 8 Contributor II

    Wow, I understand it clearly.
    Thank you very much for your kind help.


Sign In or Register to comment.