To handle null and N/A and 0 and special characters

[#1]

Policy	Issue Agent	Producer
111	120	123
111	001@	Null
112	190'	0

Hi friends,do needful from you .have table with some columns while loading into qlik need to check constrains

Policy column should not have any repeated values uniquely ,Issue Agent column not to have ascii or special char and producer not to have null values.above source  are not to load into qlik showing as error msg

[JonnyPoole]

Below see the WHERE clause for all filters. You can keep only the characters you want in keepchar() . Wasn't sure if letters and numbers were ok or just numbers.

also for true nulls, you will need to use  'not isnull(Producer)'  rather than Producer='NULL'

-------------------------------

LOAD

  Distinct

  Policy,

     [Issue Agent],

     Producer

FROM

[http://community.qlik.com/thread/138828]

(html, codepage is 1252, embedded labels, table is @1)

where

  (

  len( upper( [Issue Agent])) = len( keepchar( upper([Issue Agent]),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'))

  and

  Producer<>'0'

  and

  Producer<>'NULL'

  )

;

[#3]

Thanx for your solution but problem is while loading data into qlik to display error messages with particular column has null values