Food for Thought - Episode 6

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.

Posted at : Error and Fix Travel // 12:07 AM
Kategori:

1 comments:

  1. 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

 
geekarticles.blogspot.com. Powered by Blogger.