Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |