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?

[apathetichell]

This matches your output - but I think there might be more to what you need.

[clarrock]

@apathetichell RIT and RCT are the same the digits post that could vary.. Sometimes 1 digit to 5 digits.

T with digits should be ignored. Also there might be digits in the Name eg HIT 7-JU T689 those should also be ignore if there's no RIT+digits and RCT+digit (no space) 

[apathetichell]

So does the workflow I posted make sense?

It matches your output and does ID/RIT/RCT and the corresponding number matches.