Skip to main content
bjoern-koth
Adobe Employee
bjoern-kothAdobe Employee
Adobe Employee
Sep 16, 2024 8:20 AM UTC
Solved

AEP Datastream Data Prep - Function to force string conversion

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.
bjoern-koth
bjoern-kothAccepted solution
Adobe Employee
Sep 18, 2024 8:19 AM UTC

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

Cheers from Switzerland!
View in thread

4 replies

RiteshY18
Community Advisor
RiteshY18Community Advisor
Community Advisor
Sep 17, 2024 6:56 PM UTC

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

Translate
    bjoern-koth
    Adobe Employee
    bjoern-kothAdobe EmployeeAuthor
    Adobe Employee
    Sep 17, 2024 7:00 PM UTC

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

     

    Translate
    Cheers from Switzerland!
      RiteshY18
      Community Advisor
      RiteshY18Community Advisor
      Community Advisor
      Sep 17, 2024 7:49 PM UTC

      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 

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...