we have three columns and two rows. col1 col2 col3 a b c want to cha

we have three columns and two rows.
col1 col2 col3
a b c
want to change into 2 columns and 3 rows ,how?
col1 a
col2 b
col3 c
which transformation u'll use and how?

Question Posted / minisweet85

3 Answers
8004 Views
Cognizant, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns a..

Answer / sbvprasad

by using normalizer T/r u can do the above logic

Is This Answer Correct ?

8 Yes

0 No

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns a..

Answer / abhishek kumar(abhisheklalmca@

src->sq->normalizer->expression->target
In normalizer--
c1(column name)- 3(occurs)-string(datatype)

In Expression--

o_c1 -(output port)
decode(GCID_c1,1,'col1',2,'col2',3,'col3')

connect
o_c1(expression) to c1( target port)
c1(exp) to c2(target) port
target should be like this
C1 C2
---------- -----
col1 a
col2 b
col3 c

thanks
abhishek

Is This Answer Correct ?

6 Yes

0 No

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns a..

Answer / ravi

USE NORMALIZER TRANSFORMATION

Is This Answer Correct ?

0 Yes

0 No

Post New Answer