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
------------------------------

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
------------------------------
"