ADF reading multiple txt files, there are two types of txt files, 1 type has 18 cols, the other has 24.
The first 18 columns are the same in both types of files, Type 2 only has an additional 6.
If i create my sink mapping with a 24 col file, the pipeline fails when it tries to read an 18 col file
Column 'Prop_19' specified in column mapping cannot be found in source data.
My sink table has 24 columns.