hi all.
I am comparing 2 same columns called "To/From" from 2 different lists.
1. Get all items from sp list 1
2. get all items from sp list 2
3.
if there are at least 1 same value, then new variable will be applied according to condition
the problem is, the flow search for all, therefore the variables become a lot, not once. let's say 1st item. this is the example of the output.
AB is a redundancy in prior transactions. AB is a redundancy in prior transactions.AB is not a prior transaction - frequency, redundancy, value.
Supposedly, the answer is "AB is a redundancy in prior transactions" since there are 2 redundants here.
can anyone help?