Is QlikView ETL to Support Error Handling

[Anonymous]

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?

[engishfaque]

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

[Anonymous]

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

[jagan]

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.

[Anonymous]

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

[#6]

Check this blog post

Error Handling in Qlikview | Business Intelligence

[Anonymous]

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