topic Re: Source Data validation in Qlikveiw in QlikView

Source Data validation in Qlikveiw

Mon, 24 Jun 2013 10:16:36 GMT

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.

Re: Source Data validation in Qlikveiw

Gysbert_Wassenaar — Mon, 24 Jun 2013 10:28:51 GMT

Maybe this document can help.

Re: Source Data validation in Qlikveiw

Mon, 24 Jun 2013 10:47:46 GMT

I could not able to open the document. Please help to resend again.

Re: Source Data validation in Qlikveiw

parthiband — Mon, 24 Jun 2013 11:02:45 GMT

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!!!

Re: Source Data validation in Qlikveiw

Mon, 24 Jun 2013 11:16:22 GMT

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.

Re: Source Data validation in Qlikveiw

parthiband — Mon, 24 Jun 2013 11:31:18 GMT

Oops..

Sorry..

I understood..

Yeah its possible..

Will tell u now

Re: Source Data validation in Qlikveiw

parthiband — Mon, 24 Jun 2013 12:24:39 GMT

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