Need Blob to text conversion in Data Sphere

[gireesh0909]

Hi folks,

I have table in S/4 hana STXl to store the long text for all other tables which i am using it in Data sphere to get text but i am failing to convert the clustd value  TO_CHAR(TO_NCLOB(TO_BINARY('FF06020102028000343130330000000063010000121F9D0232663E060606461E20C1C0CA80058430F8307832F831B832AC85A85C05166601538C1CEB2082FBA0', 'HEX'))) text but it was giving an error for conversion.

Could anyone please help me here to convert this in data sphere or any suggestion would be helpful.

[Simon_Ye]

what's the data type of column "clustd", what's the target data type? if you want to convert binary to string, try function BINTOSTR

[gireesh0909]

Source data type of clustd from STXl table is large binary with data shown earlier like FF017FF like that and target data type is string with text like repaying the amount like that.

I tried with bintostr but it was giving only FF017FF same as what ever we have.

Could you please anyone can help