The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello,
I am trying to do a join on snowflake database when loading data but I got an error that "The field already exists in the record". What does it mean? That there can't be same column/field name in both tables? I want just to obtain LEFT JOIN,. It doesn't look like something extraordinary
select * from "Database"."Schema"."Table" as JOB
JOIN "Database"."Schema"."Table" as CAT
ON JOB.ID=CAT.ID
AND JOB.CODE=CAT.CODE
I have filled server, warehouse, role, database in advanced options of Snowflake connector
Thank you for your help
Solved! Go to Solution.
@Pbiuserr , You can not take the same column name from both tables. So take all fields from one table and selected them from another table, rename the columns in the query if needed
select JOB,*, CAT.ID as cat_ID from "Database"."Schema"."Table" as JOB
JOIN "Database"."Schema"."Table" as CAT
ON JOB.ID=CAT.ID
AND JOB.CODE=CAT.CODE
@Pbiuserr , You can not take the same column name from both tables. So take all fields from one table and selected them from another table, rename the columns in the query if needed
select JOB,*, CAT.ID as cat_ID from "Database"."Schema"."Table" as JOB
JOIN "Database"."Schema"."Table" as CAT
ON JOB.ID=CAT.ID
AND JOB.CODE=CAT.CODE
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
158 | |
136 | |
133 | |
81 | |
61 |