title: Azure Data Factory mapping 2 columns in one column
body: <p>Can somebody help me solving the error am getting in concatenating the two columns i.e <code>first name</code> and <code>last name</code> from my text file and merging the two columns into one name column in my <strong>Azure SQL database</strong> as a <code>sink</code> in <strong>Azure Data Factory</strong> and another question is that I want to choose the first letter of the column gender that is <code>M</code> or <code>F</code> for <em>male</em> and female respectively from the source text file and changing it to one letter M or F in my gender column in the Azure data factory pipeline <a href="https://i.stack.imgur.com/TnrVu.png" rel="nofollow noreferrer">enter image description here</a>?</p>
  
  <ul>
  <li><strong>Update 1</strong></li>
  </ul>
  
  <p>My table name is [dbo].[Contact] and after applying this procedure am getting this error, and my columns names in the text file has space in between them, like First Name and Last Name, does that create a problem too?</p>
  
  <p><a href="https://i.stack.imgur.com/TZ24f.png" rel="nofollow noreferrer">enter image description here</a></p>