Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?