QuestionQ12

VerifiedAEP Foundation

An Adobe Journey Optimizer expert is ingesting customer profiles from cloud storage by using CSV files. While creating the data flow to ingest this data, the expert notices that the column headers contain spaces (for example, Email Address). The requirement is to convert every value in that column to lowercase.

Which expression can be used to apply this transformation?

Explanation

Adobe Experience Platform Data Prep uses lower() to convert a string to lowercase. A source field name that contains a space must be wrapped in ${...}, so lower(${Email Address}) correctly references and transforms the column.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!