Skip to Content
0
Apr 23, 2014 at 06:47 AM

Duplicate columns created in attribute view

774 Views

Hi

I created an attribute view as shown in the video Creating an attribute view | SAP HANA using the data given. After creating the attribute view as per the video, when I preview the data in the attribute view, I see that all the columns are created twice. For instance there is Company Name and Company Name 1, Contact_Name and Contact_Name1, ContactTitle and ContactTitle1 and so on. This has happened for all the fields.

I checked the table in the schema to see if there are duplicate fields there. But the DIMSupplier table in the STS schema has no duplicate fields.

What I want to know is how were these duplicate fields created in this attribute view and how do I remove them? I checked the output fields and there also there are no duplicate fields.

When I right click on the attribute view and select data preview, and then under the tab "Distinct Values" I can see all these duplicate field names. I am trying to delete these duplicate field names but I am getting an error message that the field you are trying to delete is being used elsewhere hence it cannot be delete.

Can anyone please advise how to fix this error.

Thank you.

Regards,

Pavan.