Using Monarch DPS and/or Automator, are we able to add the data file name into the exported data?

Tony_20992
Tony_20992 Altair Community Member
edited November 2021 in Community Q&A

Hi, looking to add or reference the original file name from which data was trapped and captured.  Is there a way to have this referenced within the data output?  Process I'm creating is using Monarch Data Prep Studio workspace and Automator.  Thank you.  

Tagged:

Best Answer

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited November 2021 Answer ✓

    Hi Tony,

    Are you trying to add that information to the file export name? Or have it as a column within the data exported?

    • If you're adding it to the file name you can use the naming macro. See the first image
    • If you're trying to add it to as metadata within the data, as a column, you'll need to update you workspace to include it as such. Here's an example of where you can do it: See the second image.

    image

     

    image

Answers

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited November 2021 Answer ✓

    Hi Tony,

    Are you trying to add that information to the file export name? Or have it as a column within the data exported?

    • If you're adding it to the file name you can use the naming macro. See the first image
    • If you're trying to add it to as metadata within the data, as a column, you'll need to update you workspace to include it as such. Here's an example of where you can do it: See the second image.

    image

     

    image

  • Tony_20992
    Tony_20992 Altair Community Member
    edited November 2021

    Hi Baba, 

    Thank you again, the second scenario where its added to the metadata is what I am trying to create.  This is perfect!

     
  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited November 2021

    Hi Baba, 

    Thank you again, the second scenario where its added to the metadata is what I am trying to create.  This is perfect!

     

    You're very welcome. We plan on putting together a series of self-service content for Monarch Server, just like we have for Monarch Desktop. Stay tuned :-)

     

    Here's the content we have for Monarch Desktop so far; we're constantly adding to it, so if you have a request for something that's not covered please let us know. Happy Learning :-)

    Monarch Success Plan

  • Tony_20992
    Tony_20992 Altair Community Member
    edited November 2021

    Thank you Baba, I attempted to view the link but I am only getting the below screen?

    image

     
  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited November 2021

    Thank you Baba, I attempted to view the link but I am only getting the below screen?

    image

     

    Yes my apologies. I just added some new content to it which puts it into an approval workflow for our administrator to review. I'll try and make sure we add new content at a specific period in time so users can always view the blog.

    If you check back later today or early tomorrow morning it should be updated. Sorry about that!

    Here's a screenshot of what's in there at the moment;

    image