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.
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)
Please see the attached workflow that demonstrates your query.
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?
Would you able to attached screenshot of the solution? i am trying the exact query.