Forum Discussion

Birdjo's avatar
Birdjo
Resolver 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
Resolver II
8 years ago

Hello cwebb,

Would you, please, be more specific?
I have already tried setting the type in the function like this

= Table.ExpandTableColumn(#"Merged Queries", "Shifts", {"Personnel Number"}, {"Personnel number"}, type text)

But it won't works because Table.ExpandTableColumn doesn't accept a fifth parameter.

Table.NestedJoin function also doesn't allow a parameter for setting types.