How to transpose row input data into multiple columns

Edith1 — Fri, 09 Oct 2020 17:15:43 GMT

Hello all, thanks in advance for all your help. I am a new user in Talend Studio and now I'm working on a new challenge and don't know how to extract the following data from the tRestClient API response "string" column.

Here is the "string" example of the input:

Version FY21 Revised

Lss:Ldgr L4:All Sal,COLA?,COLA %,Fur?,Fur %,EPR?,FY20 Fringe,FY21 Fringe,Compute FTE,Filter?,CF: COLA?,CF: General

5000:Faculty Base,true,0,true,0,true,0.194,0.116,1,true,1,1

5005:Faculty Additional Department,true,0,false,0,true,0.194,0.116,0,true,1,1

Here is what I need to do:

I'd like the 1st row of data up to the newline "\n" to extract as the 1st column (Name)

The 2nd row of data to extract into multiple columns. The 1st data up to the comma "," is the 2nd column (Heading_Name) and the rest as column (Heading_Type)

The 3rd row of data to extract into multiple columns. The 1st data up to the comma "," is the 3rd column (Heading_Data) and the rest as column (Type_Data)

Here is what it should look like after converting those rows into columns:

topic How to transpose row input data into multiple columns in Talend Studio

How to transpose row input data into multiple columns