What I have:
I have a csv of 4 values containing all possible permutations of x items (for this example say 4 different strings) with repetition (dt_1). I have a different csv containing some permutations (dt_2).
What I want to do:
I want to check if a row from dt_1 is present in dt_2, irregardless of the order of items… but can’t figure out a way to do this, so far my searches in the forum has left me none the wiser.
Example, row from dt_1 that contains the 257 possible permutations of apples, oranges, banans and grapes:
apple, apple, banana, orange
In dt_2 there is no row with this exact order, but there is the following row:
apple, banana, apple, orange.
I want to say that these two rows match, and copy the rows from dt_1 not present in any permutation in dt_2 to a new datatable.
(my first post here after a long time lurking and learning, allow me to use this occasion to thank all the great contributors in here for amazing work - I have learned a lot searching around in here!)