Scenario: A column contains both numeric and alpha numeric values in it (see example below):
Source column
ABC
123
DEF
456
GHI
789
JKL
101
Challenge: Segregate these values into two columns one for numeric only and another one for alpha numeric values (see below)
Numeric Only - Alpha Only
123 - ABC
456 - DEF
789 - GHI
101 - JKL
Give this challenge a shot. Reply.
Read column values and use alpha function in the transformer stage in the constraints and allow the segregated the values into Numeric only or Aplha only columns.
ReplyDelete