Forum Discussion

Birdjo's avatar
Birdjo
Icon for Resolver II rankResolver II
8 years ago
Solved

Set column type while expanding from merged query

Hello, Here's a quick question: I am expanding a column after merging. In the source the column type is text and has values like: 0333, 0555, 0888 While expanding it expands like a whole number an...
Need Help
  • Birdjo's avatar
    Birdjo
    8 years ago

    cwebb 

    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!

Birdjo's avatar
Birdjo
Icon for Resolver II rankResolver II
8 years ago

cwebb

I 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-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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