Forum Discussion
The column 'Column14' table wasn't found
Hello,
I am having problem in refreshing the data. I need to update the data and had removed the column14 and column15 in my original table before. Other identical errors I've seen is you have to remove the column in Query Editor. But when I removed it nothing happens.
Here's the code in #"Changed Type" line.
Before removing
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"1", Int64.Type}, {"2", type text}, {"3", type text}, {"4", type date}, {"5", type text}, {"6", type text}, {"Column14", type any}, {"Column15", type any}}),
After removing
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"1", Int64.Type}, {"2", type text}, {"3", type text}, {"4", type date}, {"5", type text}, {"6", type text}}),
The error below still exist. Please advise on how can I make this work. Thank you so much.
Anonymous , There is step # remove column, That is using column 14 and 15. Make sure not steps refer to these two.
remove that line. (Third last line)
3 Replies
- amitchandak
Super User
Anonymous , There is step # remove column, That is using column 14 and 15. Make sure not steps refer to these two.
remove that line. (Third last line)
Hi amitchandak ,
I removed the third line from the last, now my code looks like this but I got this error.
let
Source = Excel.Workbook(File.Contents("C:\Users.xlsx"), null, true),
#"Weekly Report - Transformed_Sheet" = Source{[Item="Weekly Report - Transformed",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Weekly Report - Transformed_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"1", Int64.Type}, {"2", type text}, {"3", type text}, {"4", type date}, {"5", type text}, {"6", type text}})
in
#"Removed Columns"It works now! I removed the #"Removed Columns" last line and changed it to #"Changed Type". Thank you amitchandak