Forum Discussion
Split lines in rows to table M Query
@Denis_Slav
Duplicate the source and divide by delimiter using the line font into rows and merge the two queries.You can download the file: HERE
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click the Thumbs-Up icon on the right if you like this answer 🙂
Denis_Slav
How does your source data look like?. Both the tables you have shown are same.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Fowmy Greg_Deckler amitchandak edhans Yes, it's not so clear then I supose. ))
My source is PDF file, in source it like matrix, and I need to create table like KEY-VALUE. To make more clear I create a sample:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("XYo9DoAgDEbv0sTN8I/UkR0TBzbKFXr/0Zq64PDy+vJ1DGiZuCHx3YUg94sXIjEmizKFRFxOIVuU79qIrw47OOPcRvzJm6jKqrTUsZRXBVX5F8z5AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t])
in
SourceAs you can see, there are one raw with data in several lines with [Line Feed} in end of each line. I need generate separate raw from each line, like this sample:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8jFV0lEy0DMwUFWK1QFyLVC4ASFArqGeMYxrBOaawhRDuCZAXiwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t])
in
SourceBasic split by delimiter is not appropriate, because it's create for each line in Column 1 the same value in Column2.
@Denis_Slav
Duplicate the source and divide by delimiter using the line font into rows and merge the two queries.You can download the file: HERE
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click the Thumbs-Up icon on the right if you like this answer 🙂