In-DB Select Distinct on Two Columns Using Filter In-DB

[dshaw]

I need a little bit of syntax help writing a SQL Code for Select Distinct on multiple columns using the in-DB filter tool.  I only want records that have the same zip code and ID.  I want to go this route so I don't have to stream out the data and use the unique tool.

[BenMoss · Accepted solution]

I would try the In-DB summerize tool; if you configure this with the ‘first’ summerize type you can achieve exactly the same as you would with an In-DB unique.

Ben

[dshaw]

I don't see "First" in the In-DB Tool.  Perhaps, I need an upgrade?  I am using 11.7.

[BenMoss]

According to the help it has exited in the in database summerize tool since version 9.5.

I believe it sits under the ‘string’ group.

https://help.alteryx.com/9.5/LockInSummarize.htm

[dshaw]

That is strange.  I don't have that option for the In-DB tool.  I felt like I have seen this before.  Nonetheless, I think Group By without the first probably could work for my use case.  I will give this a try.  If you have any other thoughts please share.  Thanks.

[wmsalamanca]

I need some help writing the sql statement in the 

Filter In-DB Tool

Select a,b,c, d from table xyz

where a,b,c is null