Power Query

[itsgrady]

I need to change a column on the final output of the Power Query. The Power Query combines two different spreadsheets into one spreadsheet. The owner of the spreadsheets added one column on one of the spreadsheets. Now, when the Power Query run, it pulls the wrong column on the combine spreadsheet. I would like to change the column back to the correct column. I'm having a difficult time trying to change the column back to the correct column. I am not able to see all of the columns available on the spreadsheet and I'm not sure how to make the simple column change.

I'm new to Power Query but I am able to navigate some in the Edit Mode.

Thanks for any help you can give...

 

[smozgur]

It depends on the data model, and I can't say anything without seeing the merged data tables. However, if you analyze the steps in the Power Query editor, you might see the step (depending on the method used to generate the result) that columns are selected and include the new column.

Another approach could be to copy & paste the M code from the Power Query Advanced Editor and see if we can figure it out from the existing code.

 

[itsgrady]

It depends on the data model, and I can't say anything without seeing the merged data tables. However, if you analyze the steps in the Power Query editor, you might see the step (depending on the method used to generate the result) that columns are selected and include the new column.

Another approach could be to copy & paste the M code from the Power Query Advanced Editor and see if we can figure it out from the existing code.

View attachment 88125

Another issue that I am having is that one column is not returning all of the data. I have about 38,000 rows in the file. One column returns some of the data but it is not returning all of the data. It is strange, but I can't figure out why it only returns some of the data in that one column. Not sure what I need to send to see if you could point me in the right direction.