Remove Duplicates after Map Function

[guillaume0314]

Dear friends:

I have a MAP within a LET which changes values from old ones to new ones when conditions are met:

Please Login or Register  to view this content.

Problem, I may end up with duplicates values in this MAP. Strangely, when I type:

Please Login or Register  to view this content.

It does not remove the duplicates. Where did I make a mistake in this code?

Any ideas here?

Please see pic + workbook. Thank you.

remove_duplicates_after_map.jpg

[WideBoyDixon]

Change this in the middle of your function:

Please Login or Register  to view this content.

... or whatever is used for "TRUE" in the French localized version

WBD

[guillaume0314]

Thanks WBD it works perfectly. I will make sure to add this parameter from now on!

Congrats for your French school lessons old memories, "VRAI" being "TRUE" for real ;-)

[WideBoyDixon]

UNIQUE() takes unique rows but your data was in columns. The ",VRAI" parameter tells UNIQUE to extract unique columns so you should only add it if necessary.

WBD

[guillaume0314]

Got it. Thanks.