Talend community forum / [resolved] Concatenate columns data into one column

Jai · 2011-04-28 11:59:58

Tags: [bug, context, database, date, deployment, development, mssql, oracle, positional file, PostgreSQL, tos3.0.0]

Can we concatenate two columns data into one column , Ex: Table1: Start date and Enddate columns need to be concatenated into a range column of Table 2 ??
Any suggestions ?

Thanks
Jai

shong · 2011-04-28 12:23:05

Hi Jai

Yes, it is possible, can you show us an example to explain your request so that we can give you more precise answer.

Best regards
Shong

Jai · 2011-04-28 14:20:44

Hi shong , i figured it out

I am using row1.StartDate + "----"+ row1.EndDate expression in tmap and its working fine..

Thanks
Jai

Announcement

Unanswered posts

#1 2011-04-28 11:59:58

[resolved] Concatenate columns data into one column

#2 2011-04-28 12:23:05

Re: [resolved] Concatenate columns data into one column

#3 2011-04-28 14:20:44

Re: [resolved] Concatenate columns data into one column

Board footer