Hi sirs,
I just want to seek advise on how to get the result as shown in the image below… I am kind of ran out of ideas… thanks in advance ^^
Hi sirs,
I just want to seek advise on how to get the result as shown in the image below… I am kind of ran out of ideas… thanks in advance ^^
@vbaac something like this:
First thing I notice is that DuplicateItemIndices doesn’t seem to be returning all the indices with duplicate items. You’ll want to remedy that.
Second thing is that you’re using longest lacing for the == comparison. You need to make sure you’re checking every item in the initial list with every duplicate item. List.Contains with cross-product lacing would be the most efficient.
Third thing is to then check if each sublist of items passes the overall check using something like AnyTrue. Since you have to check each duplicate item you’re left with a boolean for each one. This allows you to see if any of those duplicates were found and gives you the final output that you’re looking for.
@volkan.isik @Elie.Trad @Nick_Boyts , thank you very much for all your inputs… I finally got the results I needed… ^^