Icon

03.Generate Daily Recap Report

This workflow reads
These parameters can be configured when executing the workflow from the KNIME Business Hub (Configuration Options panel)

Part 5 - Best Practices

03. Generate Daily Recap Report

Workflow description: This workflow reads

  • The new feedback and its calculated sentiment.

  • The list of users who opted-out of receiving emails

and generates a recap report containing the list of users who lately left feedback and whether a followup email can be sent to them or not. The execution waits for up-to-date data.


This workflow is finalized and doesn't have exercises.

Executed by:

WORKFLOW ACTION
(02.Feedback_Analyzer)
Wait for updated data

Before generating the report, make sure that the list of email unsubscribers has been updated today. Therefore, check the email_unsubscribers.csv file metadata and

  • If updated within the last 5 minutes, go on with the execution.

  • If not updated within the last 5 minutes, wait X seconds and check again

Read new feedback and append email_allowed field
Clean new_entries.csv file. Old feedback will not be processed again.
Create PDF report
Variable Loop End
filter file path to email_unsubscribers.csv
List Files/Folders
Counting Loop Start
Date&Time Configuration
CASE Switch End
Report Template Creator
create filename from current date
Create File/Folder Variables
Merge Variables
up: email opt-out bottom: email allowed
Reference Row Splitter
read email_unsubscribers.csv
CSV Reader
read empty file
CSV Reader
Report PDF Writer
clean file new_entries.csv
CSV Writer
Concatenate
readnew_entries.csv
CSV Reader
Path to String (Variable)
CASE Switch Start
max attempts
Integer Configuration
File last edit
email_allowed=no
Constant Value Column Appender
wait X seconds and check again
Wait...
waiting time (sec)
Integer Configuration
Saved to Daily Reports folder
Generate Daily Recap Report
email_allowed=yes
Constant Value Column Appender

Nodes

Extensions

Links