If condition not working

[#1]

Hi All,

I am my below mentioned issue from long time but couldnt able to get solution on this.

Pls help me to solve.

Below is my sample data.

Data:

<    

Applicant_Id	Applicant_status	Status_Date_Time
1	A	07/10/2016 12:00
1	B	07/10/2016 18:00
1	C	08/10/2016 13:00
1	D	08/10/2016 17:00
1	E
1	F	09/10/2016 12:00
1	G	09/10/2016 15:08
1	H	09/10/2016 16:00
2	A	07/10/2016 12:00
2	B	07/10/2016 18:00
2	C
2	D	08/10/2016 17:00
2	E
2	F	09/10/2016 12:00
2	G
2	H

Requirement:

<          

Applicant_id	A	B	C	D	E	F	G	H
1	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes
2	Yes	Yes	No	Yes	No	Yes	No	No

I need to show my data in above way.

I am using if but it is not working .

if(Applicant_status='A','Yes','No') .

Can anybody help me with this. This is very urgent .

[sunny_talwar]

Check this link out:

The Generic Load

[Anonymous]

If (Applicant_status<>"" and Status_Date_Time="","NO","YES")

[rupamjyotidas]

Seems to be working

if(Applicant_status='A','Yes','No') as StatusFlag

Can you provide more explanation on what you are trying to achieve

[vcanale]

Hi,
Try:

if((Applicant_Id=1 AND Applicant_status<>'' AND Status_Date_Time<>'')

  OR(Applicant_Id=2 AND Applicant_status<>'' AND Status_Date_Time<>''), 'Yes', 'NO')

[albertovarela]

Please see attached qvw