Pages

Sunday, March 17, 2013

How to insert First_Name,Last_Name for below scenario


Source:
First_Name
   Last_Name
Vijay
Jaiswal
Kuldeep
Solanki
Lalsingh
Bharti
Poornaya
Cherukmala
Rajeev
TK
Target (o/p)
First_Name
 Last_Name
VijayJaiswal
Kuldeep
Solanki
Lalsingh
Bharti
Poornaya
Cherukmala
Rajeev
TK
Solution:
Option1
You can assign serial number to Source data,then group by serial number and take write to target

Expression
Use expression to assign the same serial number to first_name and last_name

Now data will be as below
Sl
First_Name
   Last_Name
1Vijay
1
Jaiswal
2
Kuldeep
2
Solanki
3Lalsingh
3Bharti
4Poornaya
4Cherukmala
5Rajeev
5TK
Aggregator
Group by SL.As per aggregator property null values are ignored ,use max or min function to get name combination

No comments:

Post a Comment