Forum Discussion

toafk's avatar
toafk
Frequent Visitor
5 years ago
Solved

XML data containing Tables and values

I'm using XML data as input to Power Bi. 

 

This column "PiccoloConfig.Sites.Site.ServiceUnits.ServiceUnit.Resources.Resource.CustomPro.2" contains "Table" and Values.

Theese are the values in line 40.

 

How to a convert this into list, where is keep the values, if a value is present or expand the table if available?

Regards Torben

 

Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi toafk ,

    I see in your other thread opened here you already have the answer to your question (ImkeF's solution): 

     

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

     

     I believe the confusion comes from applying this step to your Source and not your previous step (#"Renamed Columns").

    Please confirm.

     

1 Reply

  • Payeras_BI's avatar
    Payeras_BI
    Solution Sage
    5 years ago

    Hi toafk ,

    I see in your other thread opened here you already have the answer to your question (ImkeF's solution): 

     

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

     

     I believe the confusion comes from applying this step to your Source and not your previous step (#"Renamed Columns").

    Please confirm.