TABLE column name change/edit

Question & Answer
1

Hi Team,

I have 2 table in sheet 1 and both the table has same column name with different data. While creating calculated field it is not allowing me to use same heading twice hence I used some prefix/ suffix . While including in visual how can I edit header as per the requirement in table column name.

Screen shot attached, in that yellow highlighted part i want to delete.

image

Thanks,
Nandan

2

image
image1118×236 9.71 KB

3

Hi Nandan, Thanks for asking, for edit any column header you need to go to below steps

Step 1 - Just select your Table visual and click on the format visual button
PFB the picture for your understanding

image

Step 2 - Then you can see a list of format visual option available in QuickSight on the Side of Menu bar.
Just select Group-by column names from the list of Format visual options and put your custom column name on the blank box.

PFB the picture for your understanding
image

2 Likes
4

Hi,

Thank you for the support. I used the above details but I can only edit 1st column name and how to edit other columns?

5

image
image1152×444 28.2 KB

6

only column 1 is from base data rest all the column is from calculated field.

7

Then you can rename the calculated field

8

Hi @Biswajit_1993,

In calculated field repeated name is not allowed. Same name used in table.

9

Let me check once from dataset end it is possible or not?

10

Hi @nandu I have attached two pictures so that you can understand the things correctly.

image

In this highlighted box I created 4 calculated field and later point of time in my Table visual type I changed the name of the calculated field .

image
image987×466 78.4 KB

Here I used the same name column for me its working please check again from your end sides.

11

@nandu

Check in format>value column names. Here you should be able to edit.

12

Hi Nandan,

Biswajit’s response on renaming columns is correct. Just that your column happened to be a measure and hence would show under Value column names as pointed out by Ramon. Marking Ramon’s answer as the solution here.

Regards,
Arun Santhosh

3 Likes