Forum Discussion

daniel_wild's avatar
daniel_wild
New Member
4 years ago

Help with expanding error

let
Source = Xml.Tables(Web.Contents(Excel.CurrentWorkbook(){[Name="URL"]}[Content]{1}[Column1])),
Table0 = Source{0}[Table],
Table1 = Table0{0}[Table],
#"Expanded analysis" = Table.ExpandTableColumn(Table1, "analysis", {"Element:Text"}, {"analysis.Element:Text"}),
#"Expanded nominaldescription" = Table.ExpandTableColumn(#"Expanded analysis", "nominaldescription", {"Element:Text"}, {"nominaldescription.Element:Text"})

in
#"Expanded nominaldescription"

When both analysis & nominal description are present they expanded and this works perfectly. However, the same data from the API does not always need to be expanded.

How do I achieve if nominal description errors on expanding then, don't expand and just show the data?

1 Reply