AEP Datastream Data Prep - Function to force string conversion

Forum|Forum|1 year ago
September 16, 2024
1 reply
1003 views

Hi all,

does anyone know of a function that converts any type into a string?
From what I have tested, I only see concat being able to perform the task, but no to_string or similar?

Cheers

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by bjoern__koth

yes, then maybe at ETL level/ prior ingestion change to data to string to avoid any additional data transformation at AEP as it has the limitation @bjoern__koth

just feels like such a basic functionality which makes me wonder why it is not supported (or only with the concat workaround mentioned).

Opened a product idea: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform-ideas/aep-datastream-data-prep-function-to-force-string-conversion/idi-p/704835

RiteshY18

Community Advisor

AJO has toString() function, it should change any data type to string @bjoern__koth

bjoern__koth

Author

Community Advisor and Adobe Champion

yeah, that would be the obvious. But it does not seem to exist in the datastream data prep

Cheers from Switzerland!

RiteshY18

Community Advisor

yes, then maybe at ETL level/ prior ingestion change to data to string to avoid any additional data transformation at AEP as it has the limitation @bjoern__koth

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded