Forum Discussion
Getting this data to be usuable
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.
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.