IF THEN with multiple conditions in Prepare

Lisa Callahan
Lisa Callahan Member, Infor Partner Posts: 11
in Birst

What is the proper syntax for creating multiple IF THEN conditions in a scripted source in Birst?

IF [MWRA_Enrollee_file_1.PlanCarrierCode]='A1C' THEN [PlanCarrierCode]='LBAS'
ELSE IF [MWRA_Enrollee_file_1.PlanCarrierCode]='A1D' THEN [PlanCarrierCode]='LLTD'
ELSE [PlanCarrierCode]=[MWRA_Enrollee_file_1.PlanCarrierCode]
END IF

Thank you,

Lisa

Answers

  • Diane McElhiney
    Diane McElhiney Member, Staff Posts: 33

    This IF seems a good candidate for a Custom Attribute.

  • Lisa Callahan
    Lisa Callahan Member, Infor Partner Posts: 11

    If I create a custom attribute can I still use it for the join condition in an inherited source?

Categories