Splitting single rows into multiple rows

[Anonymous]

Hi all , 
My input looks like this 
id1, presenter1, presenter2, presenter3, presenter1content,  presenter2content,  presenter3content ,presenter1knowledge, presenter2knowledge, presenter3knowledge
id2 ,presenter1, presenter2, presenter3, presenter1content,  presenter2content,  presenter3content  , presenter1knowledge, presenter2knowledge, presenter3knowledge 

I need to split single row above into multiple rows based on different presenters and my output should look like this 


id1 , presenter1 ,   presenter1content,  presenter1knowledge
id1,  presenter2 ,   presenter2content,  presenter2knowledge
id1,  presenter3 ,   presenter3content,  presenter3knowledge
id2 , presenter1 ,   presenter1content,  presenter1knowledge
id2,  presenter2 ,   presenter2content,  presenter2knowledge
id2,  presenter3 ,   presenter3content,  presenter3knowledge
 
Any help would be appreciated 
I have uploaded the screen shot below with example 

Thanks in advance 
input 



Output 

[TRF]

Hi,
Define the tFileInutDelemited schema as:


Connect tFileInutDelemited to a tSplitRow and define mappinp columns as:


That's all.

TRF