Skip to main content
Question

merge pdfs based on data in excel

  • September 23, 2025
  • 2 replies
  • 44 views
jasna
Participant
Forum|alt.badge.img+1

Hi,

I wonder if someone could help me?

I would like to merge pdf files in one folder (folder1.png)with pdf files in different folder (folder2.png) based on data in excel (merge.png). For an example, merge 1.pdf in folder1 with 421.pdf,422.pdf,423.pdf in folder2 like it says in the table. And 2.pdf in folder1 with 424.pdf, 425.pdf in folder2 and so on...

Is that possible?

Thank you,

 

Jasna

 

3 Attachments
    danilo_fme

    2 replies

    alexbiz
    Influencer
    Forum|alt.badge.img+28
    • alexbizInfluencer
    • Influencer
    • September 23, 2025

    Hey Jasna, 

    I don’t think FME can merge PDFs natively.
    However, you can achieve this using a command line tool together with the SystemCaller transformer.

    You should look at GhostScript or PDFtk
     

    Alternatively, you could also use Python with PyPDF2.
    Here’s the tutorial on how to install a Python package in FME’s Python environment:
    https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/Installing-Python-Packages.htm

     

    Draw it, map it, shape it, fix it, share it, change it, send, translate it 🎵
    hkingsbury
    danilo_fme
    jasna
    Participant
    Forum|alt.badge.img+1
    • jasnaParticipant
    • Author
    • Participant
    • September 23, 2025

    Thank you,

    I will try to do that.

    danilo_fme

    Community Stats

    32,127
    Posts
    121,961
    Replies
    39,777
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.