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
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
  • gtanaka's avatar
    gtanaka
    New Member
    3 years ago

    thank you!!!