Duplicate Issue

[tamilarasu]

Hi,

I have the below expression to concatenate two columns. But after concatenating again I got duplicate values. Can any one suggest me a expression.

= ( concat(distinct Shift_WD ,',') & ',' & Concat(Distinct Shift_Calculated,','))

Say for example, I have to remove Shift 4 in chart, (Shift 4 is present in Columns Shift_WD & Shift_Calculated)

Shift 1,Shift 4,Shift 4,Shift Issue

Thank you

[SergeyMak]

Hi Tamil,

It would be good to have a look at your app.

Could you share it?

Regards,

Sergey

[tamilarasu]

Hi Sergey,

Thanks for the prompt response. Sorry. I am not allowed to share the data. Is it possible to remove duplicate values in a cell.?

[jonathandienst · Accepted solution]

Something like this should work:

=Concat(DISTINCT Shift_WD, ',') & ',' & Concat({<Shift_Calculated -= P(Shift_WD)>} DISTINCT Shift_Calculated, ',')

HTH

Jonathan

[SergeyMak]

Yeah,

I believe so, but I can't say anything in this case without your app.

Try to replicate the problem with dummy data and share it or just use Scrambling in document properties.

Regards,

Sergey