dynamic text box

[NickHoff]

I have two mapping loads, which can be found below.

Based on my mappings I want to create a dynamic text box that displays the revenue codes in if the user selects the RoomCategory or RoomType.  I'd like to have the revenue codes displayed like 200, 201, 202, 203, ect.. dynamically..

MapRoomCategory:

MAPPING LOAD * INLINE [

    RevenueCode, RoomType

    200, ICU

    201, ICU

    202, ICU

    203, ICU

    204, ICU

    205, ICU

    207, ICU

    208, ICU

    209, ICU

    206, Stepdown

    210, ICU

    211, ICU

    212, ICU

    213, ICU

    215, ICU

    216, ICU

    217, ICU

    218, ICU

    219, ICU

    214, Stepdown

];

MapRoomType:

MAPPING LOAD * INLINE [

    RevenueCode, RoomType

    200, ICU

    201, ICU

    202, ICU

    203, ICU

    204, ICU

    205, ICU

    207, ICU

    208, ICU

    209, ICU

    206, ICUStepdown

    210, CCU

    211, CCU

    212, CCU

    213, CCU

    215, CCU

    216, CCU

    217, CCU

    218, CCU

    219, CCU

    214, CCUStepdown

];

[rubenmarin]

Hi Nick, if you are using this maps, in the load that applies the map has to load the code, create a field with this code.

If you have this code, the text box expression can be:

=Concat(RevenueCodeField, ', ')

[NickHoff]

The RevenueCode field is already in my data and =Concat(RevenueCode& ', ') doesn't work nor does =Concat(RevenueCode& '|')

I'm trying to get a list of all the revenue codes in my data, which fall in the RoomCategory mapping or RoomType mapping depending on what the user selects.

[rubenmarin]

Hi Nick, my concat has 2 parameters, first the field and second the separator, yours has only one parameter.

Yours can work but you need a blank space between 'RevenueCode' and '&'

[NickHoff]

Doesn't work, but i see the text object properties is repeating over and over.

[rubenmarin · Accepted solution]

ok, and with?:

=Concat(DISTINCT RevenueCodeField, ', ')

[NickHoff]

Thanks Ruben.