Need recommendation for reading Pivot table files

Al_22614
Al_22614 Altair Community Member
edited July 2021 in Community Q&A

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

Tagged:

Answers

  • Mahmoud
    Mahmoud
    Altair Employee
    edited July 2021

    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

Categories