filter examples after comparing two example sets

sectyn
sectyn New Altair Community Member
edited November 2024 in Community Q&A
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?
Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

Answers

  • Marco_Barradas
    Marco_Barradas
    Altair Employee
    Answer ✓
    Hi @jennyclub you should use a JOIN operator to gather data from both data sets.

  • Pradyumna_26
    Pradyumna_26 New Altair Community Member
    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
    sectyn New Altair Community Member
    A Set Minus should work for this.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.