topic Columns to row transformation in Talend Studio

Columns to row transformation

rohit1804 — Sun, 16 Jun 2019 06:22:13 GMT

Hi,

I have Column A with single row which has value as "SMILE" . My requirement is instead of single row i want rows which has each character of "SMILE" is single single rows.

Input : A

--------------

SMILE

Desired Output : A

-----------

Please Assist me ...

Re: Columns to row transformation

Anonymous — Mon, 17 Jun 2019 04:15:42 GMT

Hello,

Is your source a delimited file? Where is it from? You could read the content which is actually delimited in a column and use this column in the tExtractDelimitedFields component as input field. This content will be separated into new columns based in the delimiter.

Best regards

Sabrina

Re: Columns to row transformation

rohit1804 — Mon, 17 Jun 2019 04:32:19 GMT

Hi thanks for reply my source is file but I don't want to seperate data in columns I want to seperate it into multiple rows from single row....

Re: Columns to row transformation

Anonymous — Mon, 17 Jun 2019 05:06:52 GMT

@rohit1804

Please refer the below job flow for your use case solution.

The function used in tMap is as shown below.

row1.data.replaceAll("(.{1})", "$1;")

Could you please spare a second to mark the topic as resolved since your query has been answered. Kudos will be a bonus 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂