Combining files from folder data source, doesn' t produce all columns expected

Hi guys,

I use as datasource a folder which i created on One-Drive

The CSV files that exist in the file have some common named columns and some are not.

After auto combining, my final query doens' t have all the columns of all the files but reproduced some of them.

So the first file has A,B,C,D columns, the second A,B,D,E  and the third A,C,D,F

I expected the new query to have A,B,C,D,E,F columns, but no, some are missing

Is there a work around i can follow?

Thank you!

Kostas