SAP HANA Text Join Issue/Resolution

This blog is to address a common problem related to a “Text Join” in SAP HANA graphical modelling (SAP HANA version SP08 & below).

For Example, in the following example the text join has been setup correctly, marking ‘SPRAS’ as a language column.

And also the Default Language is set to “English”

Problem:

The model which has the text-join will get activated successfully but in some cases the data-preview will provide ‘NULL’ values for the test description

Though the text description table has values for ‘English’

Resolution:

The text join only recognizes the single character representation in the language column. So the value in the “SPRAS” column needs to be ‘E’ instead of ‘EN’ and ‘D’ instead of ‘DE’, etc.

Once we make this change of “EN” to “E”, “DE” to “D” etc , we notice that the data-preview has the correct text description.