title: ADF / Dataflow - Convert Multiple CSV to Parquet
body: <p>In ADLS Gen2, TextFiles folder has 3 CSV files. Column names are different in each file.</p>
  <p>We need to convert all 3 CSV files to 3 parquet files and put it in ParquetFiles folder</p>
  <p>I tried to use Copy Activity and it fails because the column names have empty space in it and parquet files doesn't allow it</p>
  <p>To remove spaces, I used Data flow: Source -&gt; Select (replace space by underscore in col name) and sink. This worked for a single file. When I tried to do it for all 3 files, it tries to merge 3 files and generates single file with incorrect data.</p>
  <p>How to solve this, mainly removing spaces from column names in all files. What would be the other options here?</p>