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
Counting Loop Start
CASE Switch End
read empty file
CSV Reader
clean file new_entries.csv
CSV Writer
max attempts
Integer Configuration
File last edit
waiting time (sec)
Integer Configuration
Saved to Daily Reports folder
Generate Daily Recap Report
Variable Loop End
filter file path to email_unsubscribers.csv
List Files/Folders
Date&Time Configuration
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
email_allowed=yes
Constant Value Column
email_allowed=no
Constant Value Column
Report PDF Writer
Concatenate
readnew_entries.csv
CSV Reader
Path to String (Variable)
CASE Switch Start
wait X seconds and check again
Wait...

Nodes

Extensions

Links