Jump to content


Photo

Merge two columns text/numerical into one column

Phoenix WNL Column Merge

  • Please log in to reply
3 replies to this topic

#1 gundasriram

gundasriram

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 21 September 2017 - 03:21 PM

Hello,

 

Can anyone help me with column merge, within the same worksheet. For example, I have a TRT column, individual cells include text as Ref or Test;  another column PER, individual cell include numerical as 1 or 2; I would like to create a third column with cells for Ref1 or Ref2 or Test1 or Test2. Essentially, I want new merge the text/numerical in 2 columns into a single column.

 

Any help is highly appreciated.

 

Thanks,

Sriram



#2 Ana Henry

Ana Henry

    Advanced Member

  • Members
  • PipPipPip
  • 220 posts

Posted 21 September 2017 - 03:26 PM

Hi Sriram

I would probably use the concatenate function with a custom transformation.  This is within the Data Wizard object under data tools.  If you send a project example it would be easier to help you.

 

Ana



#3 gundasriram

gundasriram

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 21 September 2017 - 03:31 PM

Hi Sriram

I would probably use the concatenate function with a custom transformation.  This is within the Data Wizard object under data tools.  If you send a project example it would be easier to help you.

 

Ana

Thanks Ana, got it.



#4 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,115 posts

Posted 21 September 2017 - 03:49 PM

Hi Siriam, in fact if you are appending a text string you just use use + between the column names. e.g treat+'_'+sub_ID Simon.

Attached Thumbnails

  • append.jpg

Edited by Simon Davis, 21 September 2017 - 03:50 PM.






Also tagged with one or more of these keywords: Phoenix, WNL, Column Merge

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users