How to map data in multiple rows to a single record in a table

[Anonymous]

I am trying to create a mapping using a router transformation. But I am unable to join the routers output groups. In detail my source file is as follows:

Record_type,Record_data
1,EmployeeNo
2,EmployeeFirstName
3,EmployeeLastName
4,EmployeeDetail1
5,EmployeeDetail2

My target is an Oracle table with columns such as

EmployeeNo,EmployeeFirstName,EmployeeLastName,EmployeeDetail1,EmployeeDetail2

Now I know that if record_type = 1, it is always EmployeeNo and so on.

How do i create a mapping for this ?

I have tried to put in a router and group it on the Record_type, but unable to link the multiple output groups to a single target.

mykfcexperience