Find non unique string in a table

Asked by Sonima on 6 Aug 2019

Latest activity Answered by Sonima on 9 Aug 2019

3 views (last 30 days)

Hi!

I have a table "TT" which I want to return the "Ticket" of non unique string in the "Alpha".

TT =
  8×2 table
  
  Ticket	Alpha
_______	________
	
29991    	AB'
29991    	CD'
29993    	EF'
30018    	GH'
30066    	IJ'
30105    	KL'
30105    	EF'
30107    	NO' 
  

here EF in not unique under "Alpha" and I want to return "30105". How can i do this?

0 Comments

3 Answers

Link

Answer by Adam Danz on 6 Aug 2019

Edited by Adam Danz on 8 Aug 2019

Accepted Answer

nonUnqIdx is a logical index of rows of TT.Alpha that are a repeat (ie, not the first instance).

[~, AlphaGroups] = ismember(TT.Alpha, unique(TT.Alpha,'stable')); % identify groups
nonUnqIdx = [1;diff(AlphaGroups)] < 1;
% Tickets for all non-unique (ie repeat) strings in Alpha
TT.Ticket(nonUnqIdx)

0 Comments

Link

Answer by Sean de Wolski on 8 Aug 2019

n = groupcounts(T.Alpha)
[~, last] = unique(T.Alpha, 'last')
T.Ticket(last(n>1))

Using the "new and shiny" groupcounts.

0 Comments

Link

Answer by Sonima on 9 Aug 2019

T.Ticket(groupcounts(T.Alpha)>1)

You are now following this question

Sonima (view profile)