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!
Advocate VCan you post a screenshot of the Query Editor showing the output of the query that gets data from Excel, before you do the merge, please? If possible could you also post the M code for all of your queries too?
Thanks,
Chris
Resolver III can't post the M Code, but trust me there is nothing that usually would cause such a thing.
Here is an image of the source and destination (the expanded column):
v-jiascu-msftMicrosoft Employee
Hi Birdjo,
The data type of the destination is number. Can you change it to Text manually?
Best Regards,
Dale
- v-jiascu-msft
Hi Birdjo,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale - Birdjo
That way the zeros are missing.