Renaming a Data Table Column
I am new to PEGA. I created a Data Table with several columns. Now I have been asked to rename a column in the Data Table. I can see where I can add new columns and edit values in the Data Table, but not where I can rename (or delete) a column.
IKOR
AU
SunTrust Bank
US
Just changing the label would be the normal solution. This was a situation where the column name was spelled incorrectly.
Pegasystems Inc.
IN
Hello David,
For display purpose you can change identifier in data table, for more information refer attached screen print.
However if you want to change the column name in database, than create new column with required name and copy the data from old property to new property in data table. Now change the old property availability to withdrawn.
Vijetha Mulky Kamath
US
Hi,
Can anyone tel me I have created new datatable but it is not been shown under data tale.What setting Do I need to do to get it diplayed?
Carelon
IN
Vijetha Mulky Kamath
US
Yes but stil is not getting displayed. Could you please explain "existence of the data class instance to be sure".
Hi David,
As far as I know, we cannot alter the column name from the data table. An ALTER query with RENAME instruction has to be written and then should be executed in SQL.
But, would like to know, why would you rename the column names. If the names are being used in display, then change the the label names rather than column names.
Cheers,
Naren