Meaning of agreggation "Any" in Pivot action


I was wondering the meaning of Aggregation “Any” in the Pivot Action. Is it the same as “No aggregation”? I’ve followed the steps to transpose a table in this post, and it worked, but I wasn’t sure about “Any”.




In general, an aggregation converts a group of values into 1 value (the aggregation result). The “Any” aggregation does it by picking only 1 arbitrary (random) value from the group and discarding the rest.

The “Any” aggregation is typically used for non-numeric values, where all values in a group are known to be the same. E.g. “Any” applied to “ABC”, “ABC”, “ABC” will return “ABC”.