🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How to create 2 different tables with different traps and information from 1 file on Altair Monarch Classic and then export in Excel format as 2 different tabs

User: "Manan Nisar"
Altair Community Member
Updated by Manan Nisar

Hello Everyone,
I'm working on 1 text file and I would like to retrieve 2 different tables with completely different information from that same 1 text file. There is no similarity in the data being extracted. Both the tables are completely independent. Also, after retrieving the tables, I want to export in Excel format as 2 different tabs in the same excel sheet. Can anyone help me in retrieving the information from the text file as 2 different tables. Appreciate for the help in advance. Thank you!!

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "Nicholas_21406"
    Altair Employee
    Accepted Answer
    Updated by Nicholas_21406
    • Yes the same Classic.prn file is used for both load plans.  If you had two different ways of pulling data from the same file, you would have to have two different .dmod model files describing those two different ways.
    • In Data Prep Studio (DPS), you would first load one of the models

    image

    • And then the your report to the load plan associated with that model

    image

    • And then add the model associated with the other way of pulling data from the report.

    image

    • This will give you your second load plan, which you would then need to add the same report to.

    image

     

    • Then select the Export button and add an export for each of your Loadplans, configuring them as shown in my previous post.

    image

    • Make sure and save your workspace when you exit.
    • In the future if you need to run the workspace with other input files, just load the same workspace and then edit the file path for each load plan to point to your latest report:

    image