i have one table with one column in this column i have three rows like 1,1,2 th

i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?

COLUMN_NAME
SHIVA
RAMU
MADHU

THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

Question Posted / shiva

3 Answers
10079 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have one table with one column in this column i have three rows like 1,1,2 then that rows populat..

Answer / srinu

seqfile->sort->transformer->removeduplicate->targer
inser file load
col1
1
1
2
in the sort
key->sort
allowduplicate->true
keychangecolumn->true
in the transformer
create the stage variable
if keychnage=1 then col1 else stagevariablename:col1
drag col1 in transformer
in the derivation area only put stagevariable
remove duplicate:
key:col1
you select last records
we will get answer
col1
11
2

Is This Answer Correct ?

14 Yes

1 No

i have one table with one column in this column i have three rows like 1,1,2 then that rows populat..

Answer / prasad

Question is not clear.

U want 1,1 records goes to one target and duplicate records goes to another target, is it right? can u plz conform this and just let me know?

Is This Answer Correct ?

0 Yes

0 No

i have one table with one column in this column i have three rows like 1,1,2 then that rows populat..

Answer / raj

Use a pivot stage

Is This Answer Correct ?

0 Yes

0 No

Post New Answer