Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to drive Prefix, base and suffix for the part number - Base should start with Number

MaheshR
7 - Meteor
  Manual Working Results
  
Details LenPrefixBaseSuffix
WXXSBA 60WXXSBA
38xxxxS 7 3xxxxxS
N805X44S 8 N805XXXS
D2TZ119XX 9D2TZ11XXX
F3DC733XXX 10F3DC7335XXX
JX7A22053UA 11JX7A22053UA
ML3B600C06EE 12ML3B600C06EE
FT1T14K733ZDD 13FT1T14K733ZDD
9L147202BD3JA6 149L147202BD3JA6
DC343F832DC35B8 15DC343F832DC35B8
8A5313E709AA35B8 168A5313E709AA35B8
NL3B1564417GC31Y6 17NL3B1564417GC31Y6
DA5354237W21AE3DN1 18DA5354237W21AE3DN1
FL3B18519A58LAF3ZHE 19FL3B18519A58LAF3ZHE
AMHC3J99501A42AA52CP 20AMHC3J99501A42AA52CP
1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

You need to give us more information to help. For example, you say "Base should start with Number" but your third row doesn't end up starting with a number? Also it's unclear how to determine the prefix from the base from the suffix - there's no logical way like length of characters to determine this

Labels
Top Solution Authors