https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Combine-CSVs-and-Keep-the-File-Name/m-p/151525#M18 <P><SPAN>In this video we show you how to combine several CSVs and also keep a column that says&nbsp;which CSV each row came from.</SPAN></P><P>&nbsp;</P><P><SPAN>This can be super heplful when the CSV's name has information that is needed in the table, like which month it came from, or which sales rep the data relates to. Once you've got the filename in the data as a column you can use all the great text transformation tools to clean up that meta data. (In this instanct Split Column by Period would do the trick nicely.)</SPAN></P><P><SPAN class="videoUrl hidden">watch?v=LPC3aPyi5BE</SPAN></P> Thu, 30 Mar 2017 16:21:08 GMT BrianGrant 2017-03-30T16:21:08Z https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Combine-CSVs-and-Keep-the-File-Name/m-p/151525#M18 <P><SPAN>In this video we show you how to combine several CSVs and also keep a column that says&nbsp;which CSV each row came from.</SPAN></P><P>&nbsp;</P><P><SPAN>This can be super heplful when the CSV's name has information that is needed in the table, like which month it came from, or which sales rep the data relates to. Once you've got the filename in the data as a column you can use all the great text transformation tools to clean up that meta data. (In this instanct Split Column by Period would do the trick nicely.)</SPAN></P><P><SPAN class="videoUrl hidden">watch?v=LPC3aPyi5BE</SPAN></P> Thu, 30 Mar 2017 16:21:08 GMT https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Combine-CSVs-and-Keep-the-File-Name/m-p/151525#M18 BrianGrant 2017-03-30T16:21:08Z