Exceptions and Error Handling

Anonymous — Tue, 28 Oct 2014 09:31:21 GMT

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

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

Re: Exceptions and Error Handling

jagan — Wed, 29 Oct 2014 06:31:12 GMT

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.

topic Exceptions and Error Handling in QlikView

Exceptions and Error Handling

Re: Exceptions and Error Handling