Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Option to rename multiple column names of Dataset

Under Review
96
Views
2
Comments

Currently customer can modify the columns 1 by 1 using "Rename" option on column. Customer is looking for an option to rename multiple columns at a time like replacing "_" with " " in the column names, making the names Proper Case, etc.

7
7 votes

Under Oracle Review · Last Updated

We are exploring some options here.

Comments

  • @Pushpa-Oracle If you have examples of common reasons for the renames in addition to the replacing of underscores with spaces, that would help us with requirements. For example, do they also lowercase, or proper case column names? what else. thanks.

  • Rank 1 - Community Starter

    Creating a dataset from a DB table should have the same automatic column renaming as the Semantic Modeler and Client tool. In those tools you can set preferences to remove underscores, change to lower case, capitalize first letter of each word.

    This makes the dataset and visualizations more easily consumed by the business analyst instead of seeing database column names.

    We need to automate the tedious task of relabeling every column name when creating a dataset from a database table.

Welcome!

It looks like you're new here. Sign in or register to get started.