I am performing an sql statement which I know will return on value, but since it is an sql I have to map the results to a record or record list.

Is there a built in service I can use to conver the record result into a string.

When I map it dirrectly, the value dissapears.

Thanks,

-Aarif

Create a pipeline variable (e.g value) and variable under record (e.g. value)…map them…it shouldnt disappear

Thank you for trying to help.

Here is what I did.

Record1

• Value1 -----------> ValueA
• Value2 -----------> ValueB

And for some reason the values don’t get carried over to ValueA or ValueB.

declaring pipeline variable will work.
I am able to get the results doing so

Use wm.pub.recordtodocument.