Show Single distinct entry from similar group of values

[Aditya_Chitale]

Hi All,

I have a requirement where if a table column has multiple similar values,  I have to show only one instance of that value (Doesn't matter against which record) and show other similar values as blank (white space).

Name	Age
A	30
B	30
C	40
D	40

In above table, I have 2 same ages per name. I have to identify such similar age count and if it is greater than 1, show only single entry against any name of that age group. (here, 30 can be shown against either either A or B and 40 against either C or D). Other remaining entries have to be replaced with white space.

Any help would be highly appreciated.

Regards,

Aditya

[anat]

test:
load * Inline [
Name,Age
A,30
B,30
C,40
D,40

];

NoConcatenate

test1:

LOAD Name,if(Age=Previous(Age),Null(),Age) as Age1,Age Resident test;
DROP Table test;

[Aditya_Chitale]

@anat thanks for the reply. But is there any way to do it in the frontend ? I don't want to alter anything in the backend.

Regards,

Aditya

[BrunPierre]

Like this perhaps?

=Aggr(Only({<Name={"=Count(Age)=1"} >} Age),Age)

[Aditya_Chitale]

@BrunPierre  Not working. Showing null values

[BrunPierre]

Do you have two brokers with the different target allocation? Maybe you can share an example.