Hi all. I have a situation where I need to exclude information from a query based on a set flag. I would like to use a case statement as shown below in my sql code and not rely on expressions.
CASE WHEN PN.SWPARTNUMBER <> A.ATNETWORKPARTNUMBER and (A.ATPARTNUMBERDISCREPANCYVALID = '1') Then 1 else 0 END as DR02_Part_Number_Validated
I have a join setup between the two tables. The field that contains the flag set to 1 is the ATPARTNUMBERDISCREPANCYVALID field. If this is true or "1" than the SWPARTNUMBER AND ATNETWORKPARTNUMBER essentially match and therefore should not be included in the table data on the sheet that pulls this information.
Any ideas are greatly appreciated.