Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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