I am building a report with 2 dimensions OLDSTUDENTS and NEWSTUDENTS with some values that are common to both. I need to create a single dimension that displays a distinct list from both dimensions. Sort of like a UNION in a sql query.
Can anyone suggest a way of doing this? Preferably in the Expression editor using a function?
You will most likely need to alter your script/data model.
If the fields found in the same table in your data model then you can concat the field values into one field and then create a link table that contains the field value.
set NullInterpret ='';
NEWSTUDENTS &'|'& OLDSTUDENTS as %students
, JOE Sam
, Frank Stein
, Tony Tiger
For each _student in FieldValueList('%students')
WHERE LEN(OLDNEWSTUDENTS) >0;
'$(_student)' as %students,
SubField('$(_student)', '|') as OLDNEWSTUDENTS
Plees ekskuse my Swenglish and or Norweglish spelling misstakes