Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Source Data validation in Qlikveiw

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.

6 Replies
MVP & Luminary
MVP & Luminary

Re: Source Data validation in Qlikveiw

Maybe this document can help.


talk is cheap, supply exceeds demand
Not applicable

Re: Source Data validation in Qlikveiw

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

parthiband
Contributor

Re: Source Data validation in Qlikveiw

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

Not applicable

Re: Source Data validation in Qlikveiw

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
Contributor

Re: Source Data validation in Qlikveiw

Oops..

Sorry..

I understood..

Yeah its possible..

Will tell u now

parthiband
Contributor

Re: Source Data validation in Qlikveiw

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