Importing files with variable number of columns

Monsignor

Board Regular
Joined
May 30, 2011
Messages
158
I noticed something odd today and I don't know if this is new or if I just never encountered this before.


  • I have 3 files in a folder and imported from the folder into Power Query.
  • 2 of the files have 2 columns, 1 file has 3 columns.
  • Power Query imported just the first 2 columns from each file.

I'm used to Power Query sometimes importing too many columns (several empty columns) rather than too few. Is there a way to tell Power Query to import all columns?
 

Forum statistics

Threads
1,078,154
Messages
5,338,537
Members
399,241
Latest member
mattyoxford

Some videos you may like

This Week's Hot Topics

Top