Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Join Action Block returning strange characters


I am using the Join action block in 11.5.3 b66 which attemps to join 3 columns in two results sets (DateTime, TagName and Value1 with DateTime, TagName, Value2). The join will break out any differences between the two sets when using the Full Outer Join.

When I run this trans the join returns all matches and differences, but for 14 of the 240 tags I get the following set of characters � in either the value1 or Value2 loction. From Google I see that they are Unicode quoting characters.

When I view the two sources before the join these � are not present.


DateTime TagName Value1 Source1 Value2 Source2

10/13/2008 0:00 FI-3715 3060.570068 VAX � ---

10/13/2008 0:00 FI-3715 � --- 3060.570068 VMS

As you can tell the values are correct and match fine. There are some differences within the 14 tags that have this problem but they are displayed the same way.

Any ideas out there?

Roger DeWeese

Former Member
Not what you were looking for? View more on this topic or Ask a question