🎉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

Need recommendation for reading Pivot table files

User: "Al_22614"
Al_22614
Altair Community Member
Updated by Al_22614

I need to build a model to read an Excel Pivot Table which was exported from a previous Monarch model.  Is there a way to pick up the Field Names, which starts on a row greater that 5, say.  Additionally, can the first Monarch format the pivot table where the key item columns will show as repeating labels.  These two features would greatly reduce the time to open pivot table files to delete the first 4 or 5 rows and setting the key item columns to "Repeat item Labels" under the Pivot Table Field Settings.

Any help would be greatly appreciated.

Thanks

Find more posts tagged with

English
Monarch
v2020.0
Sort by:
1 - 1 of 11
    User: "Mo Abdolrahim"
    Mo Abdolrahim
    Altair Employee
    Updated by Mo Abdolrahim

    Hi Al

    I suggest you use a combination of Monarch Classic and Monarch Data Prep Studio.

    I created the following pivot table in Monarch Classic v16.1.1.

    image

    I used Monarch Data Prep Studio v16.1.1 and opened the Excel file, which was exported by the Monarch Classic, as Excel Worksheet Design using trapping logic.

    image

    I then used the Excel trapping capability and extracted all data starting from row 5.

    imageAfter trapping data I trapped the column header and load it to the DPS prepare page.  I then used the Replace>Ditto function and filled in empty cells in the first column.

    image

     

    Regards

    Mo

Quick Links