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?

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.

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.

 

 

Marion_22192

Steve Caiels_21881 said:

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

Marion_22192

Nicholas_21406 said:

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 !

Mahmoud

Hi Marion,

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

Mo