Dear Colleagues,

can you please let me know if it is possible to have the distinct string PU function applied in Celonis?

In my specific case I need to know what currencies the vendors have used in the past. I can easily do the Count Distinct, which gives me the number of currencies, but I also wish to know what were these currencies. With PU_STRING_AGG I get the full list from all the documents, but I only need a string of distinct values - in my case USD and PEN. Can it be achieved?

Of course I could create a separate Olap with currency as dimension, but the point is that this table needs to be used in Action Engine, so that is why I need it in single OLAP.

Thank you in advance for any suggestions.

image1560826 19.9 KB