If statement for multiple argument

[Karim_Khan]

Hi Team,

By applying below login I am able to remove 'UNKNOWN'  from my data.

=IF([End Customer Global Ultimate Name] <>'UNKNOWN' ,[End Customer Global Ultimate Name],NULL())

But I have one more non usable field which is 'Uknown' I wanted to remove that also.

Pls help me how to apply this multiple logic.

Regards,

KK

[alexandros17]

Load again the table without the field 'Unknow'

[Anonymous]

try

if match([End Customer Global Ultimate Name],'UNKNOWN','Uknown')=0,[End Customer Global Ultimate Name],NULL())

in match you define all values you donot want

if only UNKNOWN , UnKnown or similiar you may use upper function to convert all in upper case letters

[kkkumar82]

If you mean to say you have UNKNOWN and unknown in your data, try this

=IF([End Customer Global Ultimate Name] <>'UNKNOWN' OR [End Customer Global Ultimate Name] <>'UNKNOWN' ,[End Customer Global Ultimate Name],NULL())

Thanks

Kiran Kumar

[Karim_Khan]

Tnx buddy

[Peter_Cammaert]

Or try:

=IF (UPPER([End Customer Global Ultimate Name]) <> 'UNKNOWN', [End Customer Global Ultimate Name], NULL())

to capture every possible capitalization of the word Unknown.

[sasiparupudi1]

IF([End Customer Global Ultimate Name] <>'UNKNOWN' or [End Customer Global Ultimate Name] <>'Uknown' ,[End Customer Global Ultimate Name],NULL())

[qlikviewwizard]

Please use as shown in below script:

Hi,

[qlikviewwizard]

Hope this will help you.

[Kushal_Chawda]

Try,

IF(lower(trim([End Customer Global Ultimate Name]))<>'unknown' ,[End Customer Global Ultimate Name],NULL())