topic Re: take data from one column to other in Talend Studio

take data from one column to other

Just_learner — Fri, 15 Nov 2024 21:25:06 GMT

In Talend I have one table who have one column named "column1" has data

column1

I'm from USA

I'm from India

I'm from Canada

and I want to create a new column named column two in the same table where data will be populated from the above data

column2

USA

India

Canada

After this when I will store the updated table data it will be like

column1 column2

I'm from USA USA

I'm from India India

I'm from Canada Canada

I'm able to read the table but stuck in the transformation part.

How to do the above scenario in Talend?

Anonymous — Tue, 12 Sep 2023 08:47:05 GMT

Add a new column in the output table on tMap, set its expression as:

row1.newColumn.substring(row1.newColumn.lastIndexOf(" ")+1)

//This expression is used to intercept the substring since the last space.

Hope it helps you.

Regards

Shong

Just_learner — Tue, 12 Sep 2023 12:25:38 GMT

Thanks, Shong. It worked.

Anonymous — Wed, 13 Sep 2023 02:25:48 GMT

Great, thanks for your feedback!