SQL Query in Alteryx

[ankamshetti_nagaraj]

Hi All,

I am trying to apply filter to achieve the results of the below SQL Query where clause. Could someone please help me out on getting this filters applied on the Input Tool.

WHERE LOB IN ('xyz')
AND ((a.SOURCE IN ('App') AND a.STATUS IN ('Ops')) OR (a.SOURCE IN ('Dep') AND a.DEPLOYMENTSTATE IN ('Ops', 'Act')))
AND a.APPINFO NOT IN ('Pub', 'Intr')

[alexnajm]

You can use the same N function in Alteryx, you just need to reformat the column references to have brackets

[OB] IN ('xyz')
AND (([a.SOURCE] IN ('App') AND [a.STATUS] IN ('Ops')) OR ([a.SOURCE] IN ('Dep') AND [a.DEPLOYMENTSTATE] IN ('Ops', 'Act')))
AND [a.APPINFO] NOT IN ('Pub', 'Intr')