Forum Discussion
How to prevent empty values from loading as tables instead of nulls when load is an xml file
I'm loading similar query with multiple inputs as Xml.Tables(Web.Contents(... When I drill down, often times empty xml tags come in as "Table" instead of as null values or empty string. How can ...
i have added the following lines at the end of my Power Query:
#"ReplaceEmptyTables"= Table.TransformColumnTypes(#"Sorted Rows",{{"SampleColumn1", type text},{"SampleColumn2", type text},{"SampleColumn3", type text}}),
#"Replaced Errors" = Table.ReplaceErrorValues(ReplaceEmptyTables, {{"SampleColumn1", ""}, {"SampleColumn2", ""},{"SampleColumn3", ""}})