Expand my Community achievements bar.

AEP Datastream Data Prep - Function to force string conversion

Avatar

Community Advisor

9/18/24

Description - as mentioned in this thread, currently there seems to be no to_string function to case any other type into a string. "concat" seems to be a workaround, yet still I think this is a missing feature

 

Why is this feature important to you - sometimes a schema field requires a string which will fail validation e.g., when a number is coming in. There seem to be a lot of other "to_xyz" type casting functions around, yet this may be one of the most essential ones.

 

How would you like the feature to work - provide a new function "to_string" that converts any incoming type to its string representation

 

Current Behaviour - no explicit function available. "concat" seems to work as a workaround