Forum Discussion
Why Merge/Append Queries option greyed out in Schema view?
Hi _Smrithi
Interesting, I tested myself and I see the same thing, i.e. that when in Schema view, that Merge queries and Append queries options on the ribbon are greyed out.
However, it does appear that Merge queries and Append queries are available in the ellipsis or right-click menus within the diagram:
This is the only place I can find these function in the interface. The only other option would be to write the M code by hand.
Looks like it would be worth giving some feedback on the Schema view feature 😉
Super UserHi _Smrithi
Interesting, I tested myself and I see the same thing, i.e. that when in Schema view, that Merge queries and Append queries options on the ribbon are greyed out.
However, it does appear that Merge queries and Append queries are available in the ellipsis or right-click menus within the diagram:
This is the only place I can find these function in the interface. The only other option would be to write the M code by hand.
Looks like it would be worth giving some feedback on the Schema view feature 😉