nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Siemens Community Catalyst Program

The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.

Nominate Now

Visual Process 1 export file

Melissa_21551

I am trying to set up a visual process that uses a workspace and 2 DataPrep exports. Each DataPrep Export creates a different Tab in 1 Excel File. I am trying to Distribute the completed file (with the 2 tabs) to an email list. When I choose to distribute from the last DataPrep export It only sends that 1 tab.

How can I send the final report after the the DataPrep exports have completed?

Thank you!

Melissa Falardeau

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------

Find more posts tagged with

English

Monarch

Accepted answers

Mo Abdolrahim

Hi Melissa,
Please click on the following link and download a Visual process that should assist you with sending an email with one Excel file and two tabs attached.
https://s3.amazonaws.com/DWUsers/mabdolrahim/Community/Two%20Workspaces%20one%20email.zip?AWSAccessKeyId=AKIAILG6R4OXRQPRK3GQ&Expires=1587232138&Signature=j%2BGO97BsiHK%2FQI4zsK8NmQw8zEs%3D
Before you import the process, create a named map and call it Datawatch, and add a UNC path to where your input file resides. When you import the process you will need to map it to the Datawatch named path.
The process that I created is a monitoring process, and expects two files, classjan.pdf and classfeb.pdf. You should be able to find sample input files in this folder; C:\Users\Public\Documents\Datawatch Monarch\Reports
The first data prep export creates the Excel file with one tab, and the second data prep export adds data to the same file with a new tab. The email distribution emails the final Excel file with two tabs. Please remove my email address from the email distribution.
The move distribution moves both files to a backup folder.

Regards
Mo

------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 03-18-2020 11:14 AM
From: Melissa Falardeau
Subject: Visual Process 1 export file

I am trying to set up a visual process that uses a workspace and 2 DataPrep exports. Each DataPrep Export creates a different Tab in 1 Excel File. I am trying to Distribute the completed file (with the 2 tabs) to an email list. When I choose to distribute from the last DataPrep export It only sends that 1 tab.

How can I send the final report after the the DataPrep exports have completed?

Thank you!

Melissa Falardeau

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
"

All comments

Baba_Majekodunmi_703

Hi @Melissa Falardeau,

I am checking now in my instance. I do see what you're referring to from a delivery perspective. It gives you the ability to select each individual data prep export in the distribution list. Were you able to hold CTRL and select both files for delivery? But yes let me look at this and get back to you.

If this doesn't work, we might be able to incorporate a classic export in the process. Here's a screenshot how you could potentially combine classic and data prep;

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
-------------------------------------------
Original Message:
Sent: 03-18-2020 11:14 AM
From: Melissa Falardeau
Subject: Visual Process 1 export file

I am trying to set up a visual process that uses a workspace and 2 DataPrep exports. Each DataPrep Export creates a different Tab in 1 Excel File. I am trying to Distribute the completed file (with the 2 tabs) to an email list. When I choose to distribute from the last DataPrep export It only sends that 1 tab.

How can I send the final report after the the DataPrep exports have completed?

Thank you!

Melissa Falardeau

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
"

Mo Abdolrahim

Stephen_Smay

Hey Melissa, the critical component that'll you see in this screenshot and in the one Mo sent is the gray line/arrow between the two exports and then to the distribution node. That line represents the "execution flow" of the process and informs the server that each node must complete before the next is executed.

------------------------------
Stephen Smay
Director of AMER Solutions Specialists, Data Intelligence
Datawatch Corporation
Bedford MA
(978) 275-8230
------------------------------
-------------------------------------------
Original Message:
Sent: 03-18-2020 11:14 AM
From: Melissa Falardeau
Subject: Visual Process 1 export file

I am trying to set up a visual process that uses a workspace and 2 DataPrep exports. Each DataPrep Export creates a different Tab in 1 Excel File. I am trying to Distribute the completed file (with the 2 tabs) to an email list. When I choose to distribute from the last DataPrep export It only sends that 1 tab.

How can I send the final report after the the DataPrep exports have completed?

Thank you!

Melissa Falardeau

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
"

Melissa_21551

Thank you everyone. The suggestions worked

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
-------------------------------------------
Original Message:
Sent: 03-18-2020 11:14 AM
From: Melissa Falardeau
Subject: Visual Process 1 export file

I am trying to set up a visual process that uses a workspace and 2 DataPrep exports. Each DataPrep Export creates a different Tab in 1 Excel File. I am trying to Distribute the completed file (with the 2 tabs) to an email list. When I choose to distribute from the last DataPrep export It only sends that 1 tab.

How can I send the final report after the the DataPrep exports have completed?

Thank you!

Melissa Falardeau

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
"

Dylan_20833

Thank you everyone. The suggestions worked

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
-------------------------------------------
Original Message:
Sent: 03-18-2020 11:14 AM
From: Melissa Falardeau
Subject: Visual Process 1 export file

I am trying to set up a visual process that uses a workspace and 2 DataPrep exports. Each DataPrep Export creates a different Tab in 1 Excel File. I am trying to Distribute the completed file (with the 2 tabs) to an email list. When I choose to distribute from the last DataPrep export It only sends that 1 tab.

How can I send the final report after the the DataPrep exports have completed?

Thank you!

Melissa Falardeau

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
"

Awesome! Thank you @Melissa Falardeau for letting us know and thank you @Mahmoud Abdolrahim @Baba Majekodunmi and @Stephen Smay for helping out!

------------------------------
Dylan Tancill
Outside Sales Account Manager
Altair Engineering Inc.
Bedford MA
+1 978-275-8204
------------------------------
-------------------------------------------
Original Message:
Sent: 03-24-2020 03:49 PM
From: Melissa Falardeau
Subject: Visual Process 1 export file

Thank you everyone. The suggestions worked

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------

Original Message:
Sent: 03-18-2020 11:14 AM
From: Melissa Falardeau
Subject: Visual Process 1 export file

I am trying to set up a visual process that uses a workspace and 2 DataPrep exports. Each DataPrep Export creates a different Tab in 1 Excel File. I am trying to Distribute the completed file (with the 2 tabs) to an email list. When I choose to distribute from the last DataPrep export It only sends that 1 tab.

How can I send the final report after the the DataPrep exports have completed?

Thank you!

Melissa Falardeau

------------------------------
Melissa Falardeau
Solutions Analyst
AmeriFirst Financial Corporation
Portage MI
(800) 466-5626 Ext # 10318
------------------------------
"

Quick Links

Upcoming Events

Advancing power electronics design with Simcenter PSIM and High-Performance Computing
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Getting Started with Faster Motor Building in Simcenter Simlab
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Practical hybrid solver workflows in Simcenter Feko
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…

View all community events