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.
Hi Experts,
Appreciate any quick help
Expression.Error: The field 'STATUS' already exists in the record
Details:
Name=STATUS
Value=
SELECT
BDE.ORDER_STATUS.STATUS,
,
BDE.SMT.STATUS
FROM
QA_DF.BDE.SM_NODE RIGHT OUTER JOIN QA_DF.BDE.ORDER_LINE ON (QA_DF.BDE.SMT_LINE.ORDER_LINE_KEY=QA_DF.BDE.ORDER_LINE.ORDER_LINE_KEY)
INNER JOIN QA_DF.BDE.ORDER_REL_STATUS ON (BDE.ORDER_LINE.ORDER_LINE_KEY=BDE.ORDER_STATUS.ORDER_LINE_KEY)
WHERE
(
BDE.ORDER_STATUS.STATUS
= '1000'
)
Hi @Dinvae ,
Not sure why based on the query, I suggest you modify the sql query to:
SELECT
*
FROM
QA_DF.BDE.SM_NODE RIGHT OUTER JOIN QA_DF.BDE.ORDER_LINE ON (QA_DF.BDE.SMT_LINE.ORDER_LINE_KEY=QA_DF.BDE.ORDER_LINE.ORDER_LINE_KEY)
INNER JOIN QA_DF.BDE.ORDER_REL_STATUS ON (BDE.ORDER_LINE.ORDER_LINE_KEY=BDE.ORDER_STATUS.ORDER_LINE_KEY)
Then see if columns "BDE.ORDER_STATUS.STATUS" and "BDE.SMT.STATUS" are contained in the result.
Best regards,
Community Support Team_yanjiang
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.