Forum Discussion

TomaKavi's avatar
TomaKavi
Icon for Helper I rankHelper I
4 years ago

Unable to expande further

I had several columns that have been expanded without a problem to a level that I need. But one of them reacted like this. Is there  a way how to expand it somehow ? As you can see the expand options is missing here.

 

 

Need Help

2 Replies

  • jennratten's avatar
    jennratten
    Icon for Super User rankSuper User
    4 years ago

    Hello - In order to expand, the cells must each have the objects needing to be expanded.  You can replace the null values with tables, like this:

    Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type table) then _ else #table({“ExpandTableColumnName”}, {{_}}) }})

     

    What steps were taken prior to this one?  What step produced the values such as 191EL?

    https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-and-power-query-in-excel/ 

  • TomaKavi's avatar
    TomaKavi
    Icon for Helper I rankHelper I
    4 years ago

    it was a simple expand like by others. The other colums are in good shape but as you can see, this was contians different types of values. The problem is that after expand it contains ,,table,, with several numbers which I can see in ,,details,, but cant extract. Any idea?