Merge multiple CSVs into one and add the file name as column

I can merge CSVs now but my question is how do i add the source file name as a column on the consolidated file?