Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

4 columns data if null, no data or miss match length those records fail and remaining pass

Nagaraju_kanna
7 - Meteor

Hi Team,

 

Below 4 columns data is null, no data or miss match length those records fail and remaining pass.
EMP
NAME
Employer
Occupation

 

Below columns always blank
Prefix
PHONE
HomeAddress1

 

Excepting Output

Column wise pass or fail

Name                    RESULT

EMP                       PASS or FAIL
NAME                     PASS or FAIL
Employer                PASS or FAIL
Occupation             PASS or FAIL

Prefix                        pass
PHONE                    pass
HomeAddress1       pass

 

Below detail report      pass records and Failed records separate

 

But I tried it's not working

1 REPLY 1
Chantelb
9 - Comet

Hi @Nagaraju_kanna ,

 

You need to put your test into one formula. See fixed workflow attached.

 

Let me know if this helps.

Labels