Forgot to add, these are the instructions I was given on this site: In EG, click Tasks->Data->Create Format to start the Create Format task (or you can just submit the code below, similar to what the task will generate) Give the format a name (ex. "MissingLabelFmt") Check Specify format width and give it a reasonable width (ex. 12) On the Define Formats page, click New Specify your desired label (ex. "Other" or "Missing") In the Range definition area, select Missing values in the Values dropdown Run the task After creating the user-defined format, apply it to your column... In the EG Query Builder (where you did the join), on the Select Data tab, double-click the MarketingZone variable Click the Change button next to the Format field Click the User Defined category and select the format you defined (ex. $MISSINGLABELFMT.) Click Ok, Ok, then Run
... View more