Forum Discussion
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 harder column and the rest of the data below to be the rows. However when I import it all comes into one row and column. I tried split by delimiter "," however, that just puts it all in the same row. What can I do?
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.
4 Replies
NewStep=Table.PromoteHeaders(#table(null,List.Transform(Text.Split(PreviousStepName,"#(lf)"),each Text.Split(_,","))))
I then get this error
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.
