Forum Discussion

diego_martinezn's avatar
diego_martinezn
Frequent Visitor
4 years ago

Losing a column when importing PDF

I'm working with a folder where I have some PDFs, all with the same structure.  I've developed a function to just upload the files to that folder and automatically apply all transformations and oper...
Need Help
edhans's avatar
edhans
Community Champion
4 years ago

I'm not sure about the PDF connector, but check out your M code in the Advanced editor. The first line for  a CSV import though might look like this:

= Csv.Document(#"C:\Users\FileList txt",[Delimiter=":", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None])

It doesn't matter if that file gets a 3rd column added, it will always only read the first two. I remove that.

= Csv.Document(#"C:\Users\FileList txt",[Delimiter=":", Encoding=1252, QuoteStyle=QuoteStyle.None])

 

See if your PDF connection has that same setting.

  • diego_martinezn's avatar
    diego_martinezn
    Frequent Visitor
    4 years ago

    Hi edhans , thanks for answering :).

    For the PDF the code generated automatically is this:

    = Pdf.Tables(File.Contents("C:\whatever direction i have the file"), [Implementation="1.3"])

     Any thoughts on how to solve the issue?

      • diego_martinezn's avatar
        diego_martinezn
        Frequent Visitor
        4 years ago

        Depending on the file (all have the same structure) it recognizes 2 or 3 tables.

        When there are 2 tables there are no problems, but when it recognizes 3 there is a column that is not loaded I don't know why. It's not that I deleted it during transformation or something like that, it is missing from the beginning.