SAP DWC - SQL View type SQLScript - INTERSECT is working - MINUS not

[DirkO]

Dear DWC enthusiasts,

in DWC I want to process in a Calculation View - SQL (type SQL Script) the MINUS operation.

This is the outcome of the validation:

Doing the same with INTERSECT:

When applying the MINUS operation in a Calculation View - SQL (type SQL) the result is as expected.

If MINUS is not supported within a Calculation View - SQL (type SQL Script) why is the keyword available?

Feature or bug?

What would be a professional workaround to achiv the MINUS result?

Many thanks for help.

Br.,

Dirk

[Sven_Knpfler · Accepted solution]

Dear Dirk,

as per my knowledge, minus and except should serve exactly the same functionality, so you could replace the "minus" operator with "except" and get the same result. "Except" is working in sql script views.

Hope that helps.

Kind regards

Sven

[DirkO · Accepted solution]

Hello Sven,

thanks "EXCEPT" does the trick.

Thank you very much.

Br.,

Dirk