Forum Discussion
one column dataset repeated records
Hi all, I have a database that is has a format like below and could be many records. I want to import and organize this so I have 7 rows and 1 column for each of the record numbers (that c...
Thanks wdx223_Daniel - i am a bit new to this, I just loaded the txt file and added a custom step with the fomula you had in Custom1 but gives me an error:
Expression.Error: We cannot convert a value of type Table to type Text.
Details:
Value=[Table]
Type=[Type]
- wdx223_Daniel
Community Champion
Custom1 = Table.Combine(Table.Group(Table.SelectRows(Table.SplitColumn(Table.FromColumns({Text.Split([YourColumnName],"#(lf)")}),"Column1",each List.Skip(Splitter.SplitTextByEachDelimiter({",",","})(_)),{"a","b"}),each [a]<>null),"a",{"n",each Table.PromoteHeaders(Table.Transpose(_))},0,(x,y)=>Byte.From(y="Record Number"))[n])
