SMTP mail notification failed

[harsha]

Hi Team,

I'm trying to load data and generating some flags according to 2 rules. And when the data gets loaded, it should mail the results based on the condition.

I have installed QlikSense SMTP connector and successfully added to my application. Currently, it is sending a mail whenever data gets loaded. However, my requirement is to send mail when a particular rule(s) gets loaded along with the Data.

*******************Data Load*******************

Unqualify *;

[Sheet1]:
LOAD
[CompanyID],
[Year],
[DataPointID],
[Value],
[Flag]
FROM [lib://Automation/Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

*******************//Rule - 1*******************

NoConcatenate

DecimalFlag:

Load *,

if(Frac(Value)>0,'WithDecimal','WithoutDecimal') as Decimal

Resident [Sheet1]

where match (DataPointID,'430');

*******************//Rule - 2*******************

NoConcatenate

Compare:

LOAD CompanyID, [Year], Value As Value1
Resident [Sheet1]
Where DataPointID=431;

Left Join(Compare)
LOAD CompanyID, [Year], Value As Value2
Resident [Sheet1]
Where DataPointID = 432;

Left Join([Sheet1])
LOAD CompanyID, If(Value1<Value2, 'Yes','No') As Compare_Flag
Resident Compare;

Drop Table Compare;

Note: I'm able to load the data and run the rules. I need to send the data to a mail.

My data looks: 

I'm able to send a notification but I want to send data once the rules are loaded

How do I send a mail once the rules are loaded along with the Data?