IF THEN with multiple conditions in Prepare

Lisa Callahan · 2025-01-17T22:25:45+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

All comments

Diane McElhiney

This IF seems a good candidate for a Custom Attribute.

Lisa Callahan

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

Enrico Menotti

https://community.developer.infor.com/discussion/440/if-then-with-multiple-conditions-in-prepare

ELSEIF here should be a single word (no space).

Enrico Menotti

https://community.developer.infor.com/discussion/comment/889#Comment_889

You want to do a Complex Join? That's not going to work with Custom Attributes (I think), because in Complex Joins you refer to columns in physical tables, while a Custom Attribute is calculated on the fly when querying the db. (I hope I'm not mistaken here.)