March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
In this video we show you how to combine several CSVs and also keep a column that says which CSV each row came from.
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.)
watch?v=LPC3aPyi5BE