Alteryx designer Discussions

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

How to represent a Filter involving a sub-query

Highlighted

How do I create a filter where the filter values are stored in a column in another table. This is done in sql by using a sub query as shown below.

Select * from TableA where TableA.filtercolumn in (select distinct filtervalue from TableB)

Highlighted
Director, Customer Enablement
Director, Customer Enablement

Please see the attached workflow that demonstrates your query.

 

Highlighted
Asteroid

Hi JoeM,

 

If I just would like to load data that are not in an exiting data-set from SQL Server, do you have any good approach? 

 

Thanks.

 

Amy

Hi Joem,

 

Would you able to attached screenshot of the solution? i am trying the exact query.

Labels