topic Re: Getting only distinct val inside the cell in App Development

Getting only distinct val inside the cell

CHRIS_Singa — Fri, 26 Sep 2025 10:41:23 GMT

Hello,

I got one question about getting the distinct value inside the cell

As you can see from the image, I would like to get only :

DT-PT

I want to avoid the repeat value. The solution must be in the script editor please.

Thank you in advance

Re: Getting only distinct val inside the cell

Lech_Miszkiewicz — Fri, 26 Sep 2025 11:09:57 GMT

Not sure about combinations you may have in your data.. but something like that could work:

,If(CODE_DEMI_TRAITEMENT like '*DT*' and CODE_DEMI_TRAITEMENT like '*PT*','DT-PT', If(CODE_DEMI_TRAITEMENT like '*DT*' and not CODE_DEMI_TRAITEMENT like '*PT*','DT', If(CODE_DEMI_TRAITEMENT like '*PT*' and not CODE_DEMI_TRAITEMENT like '*DT*','PT','OTHER' ))) as [your distinct field]

cheers

Re: Getting only distinct val inside the cell

Chanty4u — Fri, 26 Sep 2025 16:24:48 GMT

Try something like this

CleanedTable:

LOAD

Checkb1,

Concat(DISTINCT SubField(CODE_DEMI_TRAITEMENT, '-', IterNo()), '-') as CODE_DEMI_TRAITEMENT_CLEAN

Resident RawTable

While IterNo() <= SubStringCount(CODE_DEMI_TRAITEMENT, '-')+1

Group By Checkb1;