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

Did this answer your question?