This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.