MERGE: Can I have multiple SET statements based on one IF

B

Bill Anderson

Based on a field in my merge data I am trying to set multiple variables like:

If {MERGEFIELD ProgStatus} = "AD"
then {Set Variable1 "FoundIt"}
{Set Variable2 {MERGEFIELD AcadProgram} }
{Set Variable3 {MERGEFIELD AdmitTerm} }
otherwise
{Set Variable1 "Not Found"}
{Set Variable2 "" }
{Set Variable3 "" }

something like that. Or must I set up 3 separate IF tests like:
{If {MERGEFIELD ProgStatus} = "AD" {Set Variable1 "FoundIt"} {Set Variable1
"Not Found"} }

{If {MERGEFIELD ProgStatus} = "AD" {Set Variable2 {MERGEFIELD AcadProgram} }
{Set Variable2 ""} }

{If {MERGEFIELD ProgStatus} = "AD" {Set Variable3 {MERGEFIELD AdmitTerm} }
{Set Variable3 ""} }

Thanks in advance for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top