title: apply trim before copy using azure data factory
body: <p>I have a pipeline that copies files from azure datalake to azure SQL </p>
  
  <ul>
  <li>Gets Meta Data of files in a specific path in Datalake</li>
  <li><p>Loops through the output and copies the file into a database table.</p>
  
  <ul>
  <li>file <code>A.csv</code> is copied to <code>dbo.[A]</code></li>
  <li>file <code>B.csv</code> is copied to <code>dbo.[B]</code></li>
  </ul></li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/0kAkJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0kAkJ.png" alt="Get Meta Data and Copy in a For Each Loop"></a></p>
  
  <h1>Question</h1>
  
  <ul>
  <li>Is there a generic way to define a <code>trim</code> on the column values being copied ?</li>
  </ul>