topic Re: Is Null condition in IF condition statement in App Development

Is Null condition in IF condition statement

LP27 — Sat, 16 Nov 2024 05:01:56 GMT

Hi Everyone,

I have got below scenario -

Status code	PR_1	PR_2	Final
P1	08/08/19	09/07/19	0
P2	04/08/18		-
P2		07/0618	-
P3	06/03/19	12/01/19	0

So I need If condition as -

If Status code ='P2' and PR_1 is blank or PR_2 is blank , then i need to place dash('-') in the Final Column or need to Place 0. ( As shown in the above table)

Currently i have written the below code and its not working :-

if(([Status code] = 'P2') and ([PR_1] = ' ' ) or ([PR_2]= ' '),[Final] = ' -',0)

Could some one guide me with the best method, Maybe using Is null in If Condition

Thanks in advance,

LP27

Re: Is Null condition in IF condition statement

trdandamudi — Thu, 08 Aug 2019 20:22:34 GMT

Please give a try with the below code:

Data:
Load *,
if([Status code] = 'P2' and ([PR_1] = '' ) or ([PR_2]= ''),'-',0) as Final;

Load * Inline [
Status code, PR_1, PR_2
P1, 08/08/19, 09/07/19
P2, 04/08/18,
P2, ,07/0618
P3, 06/03/19, 12/01/19
];

Re: Is Null condition in IF condition statement

LP27 — Thu, 08 Aug 2019 20:38:07 GMT

I have got the same query, but still its not working.

Re: Is Null condition in IF condition statement

trdandamudi — Thu, 08 Aug 2019 21:02:59 GMT

It is working on my side. Please see the attached file:

You can also use the below code and you will get the same result:

Data:
Load *,
if([Status code] = 'P2' and (Len([PR_1]) = 0 ) or (Len([PR_2])= 0),'-',0) as Final;

Load * Inline [
Status code, PR_1, PR_2
P1, 08/08/19, 09/07/19
P2, 04/08/18,
P2,,07/0618
P3, 06/03/19, 12/01/19
];