how to convert 101 raja 101 raja sekar reddy 101 sekar---

how to convert
101 raja 101 raja sekar reddy
101 sekar---------->
101 reddy

Question Posted / rajasekarreddy

2 Answers
9431 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 red..

Answer / purushotham perumalla

Create variable ports in Expression transformation to
concat name if the number is same as follows

Assume the input field names are number and name

define the variable ports in expression transformation in
the following order

v_flag = iif(number = v_number,0,1)
v_name = iif(v_flag = 1,name,v_name ||' '||name)
v_number = number
O_name = v_name

The output of o_name will be as follows

number o_name
----------------
101 raja
101 raja sekar
101 raja sekar reddy

Add an aggregator transformation after expression and group
by number. output number and o_name from aggr to target.
As aggr outputs last row in each group by deault it will
send 101 raja sekar reddy to the output.

Is This Answer Correct ?

3 Yes

0 No

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 red..

Answer / lokesh y g

using dynamic lookup we can do it......

Is This Answer Correct ?

0 Yes

0 No

Post New Answer