topic How to combine 2 columns into one? in Talend Studio

How to combine 2 columns into one?

Anonymous — Fri, 05 Jun 2015 14:42:38 GMT

Re: How to combine 2 columns into one?

Anonymous — Fri, 05 Jun 2015 15:14:42 GMT

This is a good exercise to get familiar with the flexibility of Talend. In order to achieve this you will need a tMap and a tNormalize component.
In the tMap you need to join the Category1 and Category2 columns with a consistent separator. So in your output, you will want something like.....

row1.Category1 ";" row1.Category2

Then join the tMap output to the tNormalize component. The configuration of this component is pretty well explained here.
If you want to update the ID with a continuous sequence of 1 to n, then you can do that with several different components. An easy way is to use another tMap and use a tMap variable to count the rows. Use that counter in your output.

Re: How to combine 2 columns into one?

_AnonymousUser — Sat, 06 Jun 2015 18:04:27 GMT

Hi,
You need to use tSplitRow which is dedicated to split 1 rows in 2 or more.
Really simple to use with just one step.
Regards,
Fred

Re: How to combine 2 columns into one?

Anonymous — Sat, 06 Jun 2015 19:47:45 GMT

I forgot about the tSplitRow to be honest. I am usually dealing with data that is stored comma separated that needs to be split into different rows.

Re: How to combine 2 columns into one?

Anonymous — Thu, 05 Jul 2018 11:22:20 GMT

I want to combine of two column into one but it is an interger value. I want to combine it without using tSplitRow.

thanks,

Kanda

Re: How to combine 2 columns into one?

Anonymous — Thu, 05 Jul 2018 15:33:13 GMT

Hi ,

We can combine two columns by providing comma and concatenating in TMap and then normalizing the output based on comma.

I have provided mapping and other photos.

tmapone.PNG
combine_two_columns.PNG

Re: How to combine 2 columns into one?

Anonymous — Thu, 05 Jul 2018 16:03:20 GMT

Hi,

thank you so much much aaryan for helping me

Re: How to combine 2 columns into one?

Anonymous — Tue, 10 Sep 2019 14:16:42 GMT

Hi,

Can you please provide the step by step configuration of each component to achieve this result. I am new to Talend, I want to know. Thanks in advance!