CODEWITHSUNDEEP
excelpowerquery
Ximox
Ximox

Reputation: 5

Error: Splitting rows into separate rows on all columns in Power Query

I had a problem spliting data in rows, used the solution provided by horseyride in the following link

Splitting rows into separate rows on all columns in Power Query.

Basically I am loocking to separete a row as breaks there are.

Many thanks @horseyride. The solution works in a simular problem. However, it's poping up the following error:

Expression.Error: We cannot convert a value of type Table to type Text. Details: Value=[Table] Type=[Type]

My table is this one:

enter image description here

let
    Source = Pdf.Tables(File.Contents("C:\Users\gmall\OneDrive\EF personales\EF\Temporales\IBK_Sueldo_PEN.pdf"), [Implementation="1.3"]),
    Table002 = Source{[Id="Table002"]}[Data],
    TableTransform = Table.Combine(List.Transform(List.Transform(Table.ToRecords(Source),
        (x) => List.Transform(Record.ToList(x),each Text.Split(_,"#(lf)"))),
            each Table.FromColumns(_,Table.ColumnNames(Source))))
in
    TableTransform

Please let me know how to solve this issue:

Expression.Error: We cannot convert a value of type Table to type Text.
Details:
    Value=[Table]
    Type=[Type]

Upvotes: 0

Views: 134

Answers (1)

horseyride
horseyride

Reputation: 21428

You need to use Table002 in step3 since that is the prior step name, not Source, which was the prior step name in my other answer

let
Source = Pdf.Tables(File.Contents("C:\Users\gmall\OneDrive\EF personales\EF\Temporales\IBK_Sueldo_PEN.pdf"), [Implementation="1.3"]),
Table002 = Source{[Id="Table002"]}[Data],
TableTransform = Table.Combine(List.Transform(List.Transform(Table.ToRecords(Table002),
    (x) => List.Transform(Record.ToList(x),each Text.Split(_,"#(lf)"))),
        each Table.FromColumns(_,Table.ColumnNames(Table002))))
in
TableTransform

Upvotes: 1

Related Questions