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