Data Factory Loading multiple Files. Ignore if column doesnt exist

Question

Im loading multiple csv files using a wildcard file path and i have created parameters for the fileSystem, Directory and Filename (the csvs are in a datalake)

A few of them have a couple of columns missing. is there any way in the copy activity to continue and load and just ignore the missing columns>

Answer 1

Hello @Debbie Edwards ,

Thanks for the ask .

The fault tolrenace option will not help , here , I think you can try the option called out here .
https://learn.microsoft.com/en-us/answers/questions/152741/data-factory-loading-multiple-csv-files-is-there-a.html?childToView=154786#answer-154786

Thanks
Himanshu