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