Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

 

Labels (2)
0 Replies