Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.
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
Check this blog post
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