community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Filter from SQL table

Highlighted
Atom

Hi community,

I just started using Alteryx, and I am stuck trying to filter an Excel file based a column coming from SQL table. Have anyone had any experience with this? I appreciate for all the help I can get. Thank you!

Alteryx Certified Partner

Hey @Nick278

 

You could join your excel sheet to your SQL table and anything that comes out of the "J" will the items that match your SQL table.

 

If you can provide an example it will be easier to help you

Asteroid

You can do this by joining the column from the SQL table to the Excel file. The 'J' output will contain only the values that are found in your SQL table. Before you do the join, make sure you remove any duplicate values from the column in your SQL table by doing a Summarize or using the Unique tool.

Atom

Thank you for both of your answers! I will try this

Labels