Is there a temporary data storage for storing invalid records within my workflow ?

Question

Hi All,
 
Below is a problem description I'm facing, any help on the same will be great &#128578;
 
I'm expecting the below output :

Retrieve the number of invalid records (reflected on the workflow transition line) as an integer after my workflow runs.
Fetch the above-retrieved value within an email component

Explanation of scenarios :

I have an import workflow in place containing segmentation activity with valid and invalid segmentations.
In the workflow, I can see there are - valid records = 100 & invalid records = 50 as per information on transition line after workflow run.
For every dynamic workflow run, I want to retrieve the number of invalid records (as an integer) flowing in my workflow
In above eg, I want to fetch 50 (Which is number of invalid records) as pass this value in an email component

Doubts and questions :

Is there a temporary DB created for fetching invalid records after workflow runs ?
How can I fetch the invalid number of records from transition lines and pass the same information using an email ?
How can I retrieve invalid information and send it via an email ?

Thanks,
Rutuja Kelkar
https://www.linkedin.com/in/rutuja-kelkar/

Craig_Thonis · Answer

Hello Rutuja,

To your questions:

1) A temporary table isn't created specifically for invalid records.

2) You could, however, use a split/segmentation activity to generate a compliment for your invalid records. This will create a separate transition containing these records.

3) You can feed the transition into an email activity or export it to a file using an export activity then include a link in your email to the exported file.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded