Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
swethasmilek
New Contributor III

Exceptions and Error Handling

Hi Friends have requirement while loading data into QlikView need to Catch exceptions as If a column contains null,special chars,wild spaces like as

Office:

#N/A

#N/A

#N/A

#N/A

0

0

'

-

IF(isnull([@1:3])=-1 or Len( Purgechar([@1:3], Chr(09) & Chr(32) & Chr(160) & Chr(12288)) or Text([@1:3]))='NULL',[@1:3]) as [Rep-OffOO] giving error

Am attaching sample data with code can any one help on Exceptions handling QVDGenerator_errorhandling.qvw have created variable ho hold current status error?

can any one suggest how to handle while loading into Qlik need to show case error data columns to user through mail saying data is wrong

Tags (2)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Exceptions and Error Handling

Hi,

You have give the same column [Rep-OffOO] for two columns that is why you are getting error.  You rename the second column.

IF(isnull([@1:3])=-1 or Len( Purgechar([@1:3], Chr(09) & Chr(32) & Chr(160) & Chr(12288)) or Text([@1:3]))='NULL',[@1:3]) as [Rep-OffOO]

If you just want Characters in the field then use below condition

IF(isnull([@1:3]) or Len(Purgechar([@1:3], 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')) >0, [@1:3]) as [Rep-OffOO]


Regards,

jagan.