proper reprting in email

In the below workflow, two tables are joined and then after pivoting node , matched , unmatched and total records are returned
I want to get this this output in email as a single row report. like

Total Matched Unmatched
7 7 0

After pivoting I have tried using cocatenate node, table to HTML string and then send email but I get empty data .

count_(un)matched_joiner.knwf (34.6 KB)

Hi @analytics_sharma,

Use the Joiner node and use the Row IDs as joining columns. Then convert to HTML and after that use the Table Row to Variable and pass the variable to the Send Email node.

:blush:

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.