Table Output Query

clarrock

Hi alteryx

I am trying to get an output where alteryx will check a common ID identify an RIT and RCT codes and create a table for only those names

Input File:

Name	ID
ADCB SR7 RIT456	70
SHR HUI RCT690	90
FHYTRCT HI RCT789	70
HIT RCT RWI T689	70
HKIY JOU YU	43
DKI RIT479	90
JOE 679 HUI T829	89

I trying to make alteryx find common org IDs and take only RCT and RIT numbers

Output Req:

ID	RCT	RIT
70	789	456
90	690	479

Please help

apathetichell

Can you provide a jot more detail on how the combos are determined... like does it have to be a three letter/three digit combo which matches up?

So HIT RCT RWI T689 isn't split up - right? and apparently the ones you are looking for are the only 3 letter/3 number combos with no space separating them? Should we assume that's random or reflective of the actual dataset?