Exceptions and Error Handling

[Anonymous]

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

[jagan]

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.