Does Monarch Data Prep Studio allow itemized exportation?

John Chan_21186
John Chan_21186 Altair Community Member
edited May 24 in Community Q&A

I have multiple (50+) PDF files, each segmented by date. I want to export the data to Excel / CSV files, but save them individually based on the date (ie: "Name 05.23.24.pdf" would be come "Name 05.23.24.xlsx"). I know Monarch Data Prep Studio allows multiple source files to be combined and exported in a single instance. Does Monarch Data Prep studio allow the 'mass itemized export' of multiple files in a single instance as well?

Tagged:

Answers

  • Lasse
    Lasse Altair Community Member
    edited May 24

    Hi John,

    If I understood your question correctly, there is at least one option.

    First, create a summary that includes all necessary columns plus filename column and row number column (I assume you don't want to sum anything). The filename column should be the leftmost column. Then create a summary export and there is an option Each distinct value of the first key makes a separate file or table.

     This is a quite complicated way and I would be more than happy to hear that there is a simpler way.

    -Lasse

Categories