Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to validate the source data in Qlikview? If something wrong in source data, user expecting us to provide the report for missing data. It means, If the ETL job rejects some data because of data validation or mission filed we will log it in table or flatfile and provide them as a report or send as a alert.
We need to do similar kind of think in Qlikview.
Please help to advice.
Maybe this document can help.
I could not able to open the document. Please help to resend again.
Yeah its simple..
Go to Qlikview management Console->System Tab->Set Up-> Select ur qlikview server from the management service..
On the right u ll be havingh plenty of option..
On that select the ALERTS tab..
Add the E-mail address of the people u want to send the report about the ETL failure!!!
Sorry Parthiban, you miss understood my question. I need to know, how to validate the data.
For example, I am looking for a Number field. But the received String in the filed. I need to remove/validate this kind of data before load in to QVD file.
Oops..
Sorry..
I understood..
Yeah its possible..
Will tell u now
See, i'd attached a qvw and an image of how to create an alert..
This maybe ur Sol is suppose..
In the below coding, in the XLSX file, i'd added "STRING VALUES" for SALES!!
Tab1:
LOAD * INLINE [
City, Sales
Chennai, 7000
Mumbai, 8500
Cal, 3500
];
//Join
LOAD City,
Sales
FROM
hi.xlsx
(ooxml, embedded labels, table is Sheet1);
City_Sales:
NoConcatenate
LOAD *
Resident Tab1;
DROP Table Tab1;
IF IsNum(Sales)=0 then
STORE * from City_Sales into 'C:\Users\kumar.natarajan\Desktop\City_Sales.qvd';
ENDIF
Tab1:
LOAD * INLINE [
City, Sales
Chennai, 7000
Mumbai, 8500
Cal, 3500
];
//Join
LOAD City,
Sales
FROM
hi.xlsx
(ooxml, embedded labels, table is Sheet1);
City_Sales:
NoConcatenate
LOAD *
Resident Tab1;
DROP Table Tab1;
IF IsNum(Sales)=0 then
STORE * from City_Sales into 'C:\Users\kumar.natarajan\Desktop\City_Sales.qvd';
ENDIF
So After the Creation goto Alert..
Ctrl+Alt+A
See the image attached..
Also cofigure ur mail setting to send mail in the User Preferences