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')