Re: Source Data validation in Qlikveiw - Qlik Community

Report Inappropriate Content · ‎2013-06-24

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.

Gysbert_Wassenaar · ‎2013-06-24

Maybe this document can help.

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2013-06-24

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

parthiband · ‎2013-06-24

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

Report Inappropriate Content · ‎2013-06-24

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.

parthiband · ‎2013-06-24

Oops..

Sorry..

I understood..

Yeah its possible..

Will tell u now

parthiband · ‎2013-06-24

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