topic Re: If Null then in App Development

If Null then

robin_heijt — Mon, 01 Oct 2018 16:21:54 GMT

Hi,

The following code is linked through different files with the key of "ID"

Load*, 
    If("Macro Entity Description3" ='SOUTH EUROPE', 'BU South',
    If("Macro Entity Description3" ='WEST EUROPE', 'BU West',
    If("Macro Entity Description3" ='NORTH EUROPE', 'BU North',
    If("Macro Entity Description3" ='EAST EUROPE', 'BU East',
    If("Macro Entity Description3"=Null(),'Zone','N/A'))))))))) as BU;

I am trying to achieve the following:

At the end of this IF Statement it should see if a value is blank then it should return 'Zone', however if there is no link present it should return N/A.

Right now it is returning everyone that has a blank or no connection as N/A.

What am I doing wrong?

Re: If Null then

vamsee — Mon, 01 Oct 2018 17:05:52 GMT

Instead of

If("Macro Entity Description3"=Null()

Try Isnull() or Len(Trim("Macro Entity Description3"))<0 or "Macro Entity Description3"='' or "Macro Entity Description3"=' '

Re: If Null then

robin_heijt — Mon, 01 Oct 2018 17:14:52 GMT

Unfortunately none worked. Thank you anyway.

Re: If Null then

vamsee — Mon, 01 Oct 2018 17:30:43 GMT

Try NullAsValue for the column and see.. like

NullAsValue [Macro Entity Description];

SET NullValue ='Value Not Found';

LOAD *

if.... If( Macro Entity Description ='Value Not Found', 'Zone'

Re: If Null then

maxgro — Mon, 01 Oct 2018 21:58:49 GMT

// test data

load if([Macro Entity Description3]='null', null(), [Macro Entity Description3]) as [Macro Entity Description3] inline [

Macro Entity Description3

SOUTH EUROPE

NORTH EUROPE

WEST EUROPE

EAST EUROPE

null

other

];

T2:

Load

IF(len(trim("Macro Entity Description3"))=0,

'Zone',

PICK(WILDMATCH([Macro Entity Description3],

'SOUTH EUROPE', 'WEST EUROPE', 'NORTH EUROPE', 'EAST EUROPE', '*'),

'BU South', 'BU West', 'BU North', 'BU East', 'N/A'

))

as BU

RESIDENT T;

DROP TABLE T;