Forum Discussion
Delete Hard Coded Columns after PowerQuery GroupBy
- Anonymous3 years ago
HI Anonymous,
Did you mean to make the grouped table structure dynamic changes instead of auto generated by M query functions?
If that is the case, you can try to remove the table structure parts, then the result will be recognized as common table type without detailed definitions.#"Groupby Casenummer for min_wo" = Table.Group(#"Type to date", {"CaseNumber"}, {{"Min Werkordernummer", each List.Min([wo_number]), type nullable text}, {"ALL", each _, type table}})Notice: power query will cache the table structure into the query steps and not auto sync. So if your source structure changes, you need to manually check each step to fix the issue caused by these cache structures.
Regards,
Xiaoxin Sheng
HI Anonymous,
Did you mean to make the grouped table structure dynamic changes instead of auto generated by M query functions?
If that is the case, you can try to remove the table structure parts, then the result will be recognized as common table type without detailed definitions.
#"Groupby Casenummer for min_wo" = Table.Group(#"Type to date", {"CaseNumber"}, {{"Min Werkordernummer", each List.Min([wo_number]), type nullable text}, {"ALL", each _, type table}})
Notice: power query will cache the table structure into the query steps and not auto sync. So if your source structure changes, you need to manually check each step to fix the issue caused by these cache structures.
Regards,
Xiaoxin Sheng