supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one co

supose if ur scr table contains alphanumeric values like
1,2,3,a,v,c in one columen like c1 n now u have load d data
in 2 seperare columns like ID should contain only numbers
1,2,3 n NAME col should contain a,b,cin target?How

Question Posted / shivaleela

4 Answers
13466 Views
TCS, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

Answer / sai krishna karri

Here you should not use a router as it sends the data to
two different target or two instances of the same target.

As the question here is to write the input row to to
different columns based on the value, you can just use an
expression, pass the column and create two output ports.
Output port 1 to detect if it is a numeric. And the second
output port to detect the alphabet.

output port 1 - op1
iif(is_numeric(to_int(c1)),c1)

output port 2 - op2
iif(is_alphabet(c1),c1)

Pass these two outputs to a filter and set ths condition

Not isnull(op1) or Not isnull(op2)

Link the columns to the target now. Done!

Is This Answer Correct ?

9 Yes

6 No

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

Answer / rajesh bathini

seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks
take constrain stg=0 for one link (number will go that link)
otherwise for one link(alphabets will go that link)

Is This Answer Correct ?

0 Yes

0 No

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

Answer / leo gilbert

Say your input is VAR1 which are a1 and 1a.

Have an expression transformation to create two more
variables VAR2 and VAR3 out of VAR1 using the SUBSTR
function.
VAR2 = SUBSTR(VAR1,1,1) and VAR3 = SUBSTR(VAR1,2,1).
For VAR1=a1, VAR2=a and VAR3=1
VAR1=1a, VAR2=1 and VAR3=a

Pass VAR2 and VAR3 to the router. Have one output group
with condition IS_NUMERIC(VAR2) and the other obviously is
the default group. For the first group connect VAR2 to ID
of target and VAR3 to NAME of target. For default connect
VAR2 to NAME and VAR3 to ID

Output
=====
ID NAME
= =====
1 a
1 a

Is This Answer Correct ?

0 Yes

5 No

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

Answer / bsgsr

hi, sri krishna

gud thinking,

cn i have ur mail id or contact number
my no 9866188658
bsrinivas1213@gmail.com

Is This Answer Correct ?

0 Yes

5 No

Post New Answer