Skip to Content
0
Former Member
Apr 06, 2016 at 04:06 PM

Duplicate Attribute Name in HANA procedure

894 Views

Hi,

I'm a beginner and just wanted to ask a basic question.

I have two tables

  1. Employee (emp_id, emp_name, emp_grp, salary, level, skill)
  2. Bonus (skill, level, bonus)

in my procedure I'm joining these two table and storing in variable.

I'm getting Duplicate attribute name error.

I assume this is because I had skill and level as common name in both tables.

After changing the column names in Bonus table to B_SKILL and B_LEVEL, issue was resolved.

But I believe there has to be a better way to fix this because changing the column name will not be feasible every time.