In PowerQuery I often use a combination of "Table.GroupBy" with "All rows" aggregation then "Table.AddColumn(,, Table.AddIndexColumn()" to create indexes within groups and then expand the latest grouped column. I took this idea from this website:
But when I create the second grouped column that will contain this index, all the columns in this table lose their data types.
The website says so as well.
Is there a way to make it persistent?
I mean, it is creating an object from an existing one. Shouldn't it be automatic to keep the datatypes instead of trying to infer data types each time?
By default, new column defind don't have a data type. You need changed the data type after creating column in Power Query.
Community Support Team _Caiyun Zheng
I know, and I'm asking if there is a way to avoid that
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.