OneCloud Data Prep provides the ability to leverage Variables to support transformation. The following Variables types within OneCloud Data Prep:
System: A system Variable provides information that is derived by the application at the point of execution. The following Data Prep System Variables exist:
Date - returns the Date in YYYY-MM-DD format.
Date Time - returns the Date and Time in ISO extended format for Coordinated Universal Time (UTC).
Pipeline ID - returns the numeric ID of the Pipeline.
Column: a Column Variable returns the values for any of the columns defined in the Pipeline or Mapping Group.
Runtime: A Runtime Variable allows a Data Prep editor to create a variable that accepts a value at the point of execution.
⚠️ Please note that Data Prep Variables do not support Variable Transformation.
📚 What's Next