🎉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

automating a .dpwx

Marion_22192

I created a dmod file that retrieves data from a PDF file but my client wanted to remove duplicates. So I worked on Data prep studio to remove duplicates and created a dpwx file. These treatments are automated with a .bat on the server and it works very well with the dmod (before creating the .dpwx) but we cannot get the script to work with the dpwx.  Here is the script we are trying to run: C:\Program Files\Altair Monarch 2020\Monarch.exe /rpt: \\SERVER\INJECTOR\PCSO.pdf , /mod: SERVER\dMod\PCSO Controls.dmod, /dpwx: SERVER\dMod\PCSO Controls.dpwx , /exp: SERVER\INJECTOR\PCSO.xlsx, /T  Can you help me to automate this processing?

Find more posts tagged with

English

Monarch

v2020.1

Accepted answers

All comments

Nicholas_21406

Hi Marion,

Please try the "C:\Program Files\Altair Monarch 2023\DPS\MonarchDataPrepStudio.Automation.exe" program.

MonarchDataPrepStudio.Automation.exe /? will give you a usage statement.

Community-Pasted-Attachment-1709647167950.png

Steve_Caiels

Hi Marion,

Alternatively, you can also deduplicate in the advanced properties of a .dmod Filter and continue to automate the dmod.

However, the Data Prep Studio deduplication is more flexible, so you may prefer to take a look at the solution suggested by Nicolas.

Community-Pasted-Attachment-1709647167950.png

Marion_22192

Hi Marion,

Alternatively, you can also deduplicate in the advanced properties of a .dmod Filter and continue to automate the dmod.

However, the Data Prep Studio deduplication is more flexible, so you may prefer to take a look at the solution suggested by Nicolas.

Thank you very much for this tip Steve. it works

Community-Pasted-Attachment-1709647167950.png

Marion_22192

Hi Marion,

Please try the "C:\Program Files\Altair Monarch 2023\DPS\MonarchDataPrepStudio.Automation.exe" program.

MonarchDataPrepStudio.Automation.exe /? will give you a usage statement.

Thank you for your help Nicholas !

Community-Pasted-Attachment-1709647167950.png

Mo Abdolrahim

Hi Marion,

You can create a filter in Monarch Classic Model and remove duplicate rows. Please see the following screenshots.

Community-Pasted-Attachment-1709647167950.png