Columns to add in Power Query

[JyothiGrace]

Hello all,

I added 2 columns to my source dataset and changed another column name. My query has an error "An error occurred in the ‘SourceData’ query. Expression.Error: The column 'Column3:' of the table wasn't found.

How can I fix in query editor without having to recreate the entire query?

Thanks for any help I can get!

 

[sandy666]

1. post your M code with code tags
2. probably will be enough if you remove "Changed Type" line but if it doesn't work see #1

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Adding columns to power query
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[JyothiGrace]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Adding columns to power query
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thanks Fluff for pointing that out. I am new to Excel forums so posted my question on 2 sites not aware of the rules. Noted and am aware now

 

[JyothiGrace]

1. post your M code with code tags
2. probably will be enough if you remove "Changed Type" line but if it doesn't work see #1

Thanks....I will try that