Expression.Error: The column 'Column_name' of the table wasn't found. Details: Column_name

[mohideenkalith]

Hi Everyone,

I have merged two source tables and made one result table. then i removed unnecessary columns from source tables for optimize the performance

But ended up with "Expression.Error: The column 'division' of the table wasn't found.
Details:
division"

Can someone help me solve this ?

Thanks in Advance,

Mohideen

[BA_Pete · Accepted solution]

Hi @mohideenkalith ,

Either delete the reference to [division] in the M code here:

OR...

Go back through your query steps and adjust them to ensure that the [division] column exists in the table at the step before your reorder columns step.

Pete

[mohideenkalith]

Hey @BA_Pete..,it helps!!

Thank you so much 💙