Forum Discussion
Extracting values of JSON file with null values
I have a JSON file of ACS data from the Census API that I am trying to read into Excel. The Census uses a non-standard version of JSON. It's essentially just a text file. I am not experienced with JS...
Text.Combine(List.Transform(_, each Text.From(_)??""), ",")
Thanks. When I enter this in as
= Table.TransformColumns(#"Converted to Table", {"Column1", each Text.Combine(List.Transform(_, Text.From(_)??""), ","), type text})
I get an error saying Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=[List]
Type=[Type]
