I am creating records where I have to check for a reporting employee, supervisor, add user, etc... I am using a row filter component to determine if I should pass the id value to into the appropriate target field or if it is a certain value, I need to pass a default value into that field and add a constant value like "Reporting Employee: [CR] [TAB]" or "Supervisor" [CR] [TAB]" and then I need to add the id that I checked in filter and the name of the employee from the source table into a "notes" field in the stream. Each of these values are known and included in my stream. I just need to know how to concatenate these values, or which component or combination of components will handle this process the safest and fastest way. Any help is greatly appreciated.
Thanks in advance