Is anyone familiar with the InterSection command? We get unexpected results in a small example model (attached). As far as my understanding goes, it should return those elements that are shared between two sets of values (irrespective of any sequence). However, in the example the sequence seems to matter (A2B looks fine, B2A does not) and the results do not match the exepectation. B2A should be the same to A2B, or not?
Solved! Go to Solution.
this is clearly a bug which has to be fixed.
Is it important in a current project?
Not relevant for an immediate project, but the function is interesting to sift through large data tables. What we are really looking for is a kind of query function (select rows from a target table that meets certain criteria), not sure if we would get it to work with this function.
You might want to look at the integrated SQLite database.
Here you have the full flexibility of SQL to access you data.
I know, searching data would be fast. But you have to really compose your data entries, which may become inflexible. We just have to research this part.