topic Re: Is QlikView ETL to Support Error Handling in QlikView

Is QlikView ETL to Support Error Handling

Anonymous — Wed, 17 Dec 2014 05:29:08 GMT

Hi Friends can any one help on how to do data validations in QlikView.

1)Suppose have some key columns that should not take null,Special Characters,Blank spaces i need to validate the columns while Loading itself.If Key column has Data Wrong format Validations while loading in script it has to fail and Errors are to be captured.

Any way of doing so please help on this is final Deadline on me. Tried to do in If -else logic for Office column but not achieving exactly.Hope any one help on this.

2)we will get data without Headers and Comma separator how to do validations of Total Horizontal row Count(i.e., if total count not matches to standard data count need to capture error and Fail the load script?

Re: Is QlikView ETL to Support Error Handling

engishfaque — Wed, 17 Dec 2014 05:43:50 GMT

Dear Swethasmilek,

There are different ways to perform conditional operation.

Here are the Conditional Functions,

1. if

2. alt

3. pick

4. match

5. mixmatch

6. wildmatch

7. class

Reference document is also attached kindly search "Conditional Functions".

Kind regards,

Ishfaque Ahmed

Re: Is QlikView ETL to Support Error Handling

Anonymous — Wed, 17 Dec 2014 06:25:32 GMT

I am expecting solution will Qlik support E TL functionalities of column has null or spaces to try to show case as exceptions to it user.while loading into application it should check key columns and if unsatisfy defined constrains don't load sources.

2)is there any possible to count individual rows bit count

Re: Is QlikView ETL to Support Error Handling

jagan — Wed, 17 Dec 2014 06:48:40 GMT

Hi,

Try like this

Data:

LOAD

If(Len(Trim(Field1)) = 0, 1, 0) AS ErrorFlag

FROM DataSource;

Temp:

LOAD

Sum(ErrorFlag) AS ErrorRowCount

RESIDENT Data;

LET vErrorCount = Peek('ErrorRowCount');

DROP TABLE Temp;

IF $(vErrorCount) > 0 THEN

TRACE Some data issues in table Data

//Dummy statement to throw error

LOAD * FROM dummy.csv (txt); // this file not exists just given to throw error

EXIT SCRIPT;

ENDIF

This way we can handle errors in qlikview.

Regards,

Jagan.

Re: Is QlikView ETL to Support Error Handling

Anonymous — Wed, 17 Dec 2014 10:04:56 GMT

Hi Jagan,Manually corrupted data by passing Junk value but this part of statement is not working custom Error.txt file is not working any help on this.

IF $(vErrorCount) > 0 THEN

TRACE Some data issues in table Data

//Dummy statement to throw error

LOAD * FROM dummy.csv (txt); // this file not exists just given to throw error

EXIT SCRIPT;

ENDIF

Thanks

Re: Is QlikView ETL to Support Error Handling

Wed, 17 Dec 2014 10:57:31 GMT

Check this blog post

Error Handling in Qlikview | Business Intelligence

Re: Is QlikView ETL to Support Error Handling

Anonymous — Wed, 17 Dec 2014 18:35:18 GMT

Thank Eddie but can you refer qvw I have sent is there any way capture errors in columns.can you help on logic I missed on if-else logic to check null,white spaces in key columns.I have done file,table,error mode exceptions but to perform individual key columns now