Combine Files is not capturing new columns that I added to my raw data

[GooseHelpful199]

Right now I have a folder in Sharepoint that contains all the Sales reports I need for my dashboard, which were previously all identical to each other in terms of # of columns. My Power Query has steps to check that folder, search for all files that have "Sales Report" in the name, then I click Combine Files, while also accessing "Transform Sample File" in order to remove the extra header lines.

Then as the example shows below, I was asked to add a new column, in this case "Units". No matter what I do, I cant get this new column to show up, is there an easy step that I can take in order to have this column show up in my Power Query? The only way for me to get this to show up is to filter out all the reports before Dec 18th but I need that old data as well.



I know that I could duplicate the query, filter by date (Dec 18th or later, and Dec 17th or earlier), then append the queries, but I'm assuming that there has to be an easier solution than that. Refreshing previews doesnt seem to do anything either.

[Anonymous · Accepted solution]

Hi,

Thanks for Omid_Motamedise 's concern about the problem, and i want to offer some more information for user to refer to.

hello @GooseHelpful199 , you can refer to the following sample.

The sample data is the same as you provided, and when you combine the content , the it will display a step that name "Remove other columns", click this step and remove other steps below this step.

In this step it will contain the all tables.

Then Expand the table, it will display the column name, click the load more to display all column names.

After loading all column names, then select them , and expand, then all the columns can be displayed.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian · Accepted solution]

Hi @GooseHelpful199 

The list of columns to be expanded is based on the Transform file/Sample file so if a new column is added to a different file, that new column will not be included when expanding the tables.

You can delete that step and just expand the tables manually.

[Anonymous · Accepted solution]

Hi,

Thanks for Omid_Motamedise 's concern about the problem, and i want to offer some more information for user to refer to.

hello @GooseHelpful199 , you can refer to the following sample.

The sample data is the same as you provided, and when you combine the content , the it will display a step that name "Remove other columns", click this step and remove other steps below this step.

In this step it will contain the all tables.

Then Expand the table, it will display the column name, click the load more to display all column names.

After loading all column names, then select them , and expand, then all the columns can be displayed.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GooseHelpful199]

Clicking "Load More" was the solution I was looking for, thanks so much!

[Omid_Motamedise]

Yes there is ,

Please open the Query editor, select the query and in the home tab use Advance editor, then share the code in Advance EDitor here, then I will help you what modification ist requiered