Hi,
I was wondering if there was any way to use a fixed statement in custom SQl
in my WHERE statement I have "WHERE c2.C_ORDR_WK_TYP <>'EXPECTED #1'" which gives me the correct field outputs, but in my output, it puts all of the work types. In Tableau I can easily fix this using a calculated field and saying "{FIXED [Order1]: MAX([WorkType])}" but is there a way to do this in the SQL custom code?
Thank you !
Sarah
답변 4개
Not sure if this is what you are looking for, nevertheless check this article out if not yet done so..
Replicating LOD calculations in SQL(ANSI Standard)
Good Luck !!
