Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

filter examples after comparing two example sets

I have an example set with some accounts. A second example set with the some of the accounts from the first set and a few others too. In the second example set there can be multiple entries for the same account number. How can I retrieve entries from the second set which have account numbers present in the first set?

Find more posts tagged with

AI Studio

Accepted answers

Marco_Barradas

Hi @jennyclub you should use a JOIN operator to gather data from both data sets.

All comments

Marco_Barradas

Hi @jennyclub you should use a JOIN operator to gather data from both data sets.

Pradyumna_26

Hello @MarcoBarradas even in the case of joining the two datasets, what is a way to refer to / obtain the required rows? From my understanding, a Filter Examples operator can be used, but I'm not sure how to input a variable (akin to a row index or an ID) as the reference parameter to filter. Please feel free to let me know if I need to elaborate further because I currently am building a process and just seem to have encountered a similar problem. Thanks in advance!

sectyn

A Set Minus should work for this.