Hi, I’ve been trying to create a SQL catalog item in the UI using the query below. It’s basically joining the same table twice. The query ran successfully in IDE but it’s giving me an error: Attribute '3' is duplicated. Please make sure that attributes have unique names. Can anyone help?
select x.1, x.2, ax.3 as SSN, aze.3 as EID
from table1 x
inner join table 2 ax on (x.a = ax.b) and trim(ax.c) in ('1','S','Social Security Number US')
left join table 2 aze on (x.a = aze.b) and trim(aze.c) in ('E','EMPL_PROVIDED_ID','Employee ID')
where x.last_update_date > '2023-02-08 00:00:00.000'
Best answer by Cansu
View original
