Forum Discussion
Resolver IISet column type while expanding from merged query
I am working with Excel using Excel.Workbook(Web.Contents())
In matter of fact the type doesn't matter untill I don't lose the zeros. Like 0003 > 3, 0005 > 5.
MarcelBeug the change of the data type occurs while expanding and zeros are lost. I guess there's nothing to get them back.
It is very nice how you values remain their zeros while their type is a number.My temporary solution was to change the type to a number everywhere and duplicate the column with type text in the table that I visualize. Works pretty good but it would be better if that was not necessary.
Thank you both!
Community ChampionAgree with Chris.
In any case: expanding does not change column data types nor convert values to another data type.
The column data types after expanding, are determined by the data type of the column with nested tables (before expanding).
If you have numbers after expanding, then you also have numbers before expanding.
Community ChampionBirdjo My values are texts, but they are in column with type number, which are 2 different things in Power Query.