Forum Discussion

gtanaka's avatar
gtanaka
New Member
3 years ago
Solved

Importing PDF with Power Query - values not alocated in correct cells

Hi!
I need help to fix the folloing problem:

Some values when I import PDF are being alocated in the wrong place, grouped in a cell, leaving an empty place where the value should be.

 

 

Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, gtanaka try this

    let
    Source = your_table,
    cols = Table.ToColumns(Source),
    first = List.Combine(List.RemoveNulls(List.Transform(cols{0}, (x) => Splitter.SplitTextByDelimiter("#(lf)")(x)))),
    res = Table.FromColumns({first} & List.Skip(cols, 1), Table.ColumnNames(Source))
in
    res

2 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    3 years ago

    Hello, gtanaka try this

    let
    Source = your_table,
    cols = Table.ToColumns(Source),
    first = List.Combine(List.RemoveNulls(List.Transform(cols{0}, (x) => Splitter.SplitTextByDelimiter("#(lf)")(x)))),
    res = Table.FromColumns({first} & List.Skip(cols, 1), Table.ColumnNames(Source))
in
    res