Solved: Re: Getting this data to be usuable

jakedawson · ‎02-08-2022

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?

AlexisOlson · ‎02-09-2022

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.

View solution in original post

Anonymous · ‎02-08-2022

You could probably surround that data with Csv.Document(your data).

--Nate

wdx223_Daniel · ‎02-08-2022

NewStep=Table.PromoteHeaders(#table(null,List.Transform(Text.Split(PreviousStepName,"#(lf)"),each Text.Split(_,","))))

jakedawson · ‎02-08-2022

I then get this error

AlexisOlson · ‎02-09-2022

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.