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)

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

Highlighted

Hi Joem,

 

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

Labels