Pages

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.

Error and Fix Travel

Phasellus facilisis convallis metus, ut imperdiet augue auctor nec. Duis at velit id augue lobortis porta. Sed varius, enim accumsan aliquam tincidunt, tortor urna vulputate quam, eget finibus urna est in augue.

1 comment:

  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