Forum Discussion
Solved
Getting this data to be usuable
Hey guys, This data is pulled from a HTML file that is received from an API call. when it comes in it looks like this I cant figure out how to get it usable. I want the top row to be a h...
Text.Split expects a text value for the first argument, so you need to reference a string rather than a table. One option is to use row and column to pick out a specific table cell to use. For example, #"Converted to Table"{0}[Column1] give the value in the first (index 0) row and column [Column1]. Another option might be to not convert to a table in the first place.
You could probably surround that data with Csv.Document(your data).
--Nate