Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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