How to assign a variable value to a new column created in Transform

Mahulima Contributor
edited December 2023 in General
  1. I am creating a new column (X) in Transform and I want to assign the value I created in the previous/same transform in another column (Y). How can I populate X with the value of Y column
  2. How can I select only specific columns to move forward in the next Transformation,. If I am having 100 columns in my current Filter Transformation, I want to move only 10 columns to the next transformation(Report)
  3. How can I map new column to the next transformation. Ex, I create a column "Name" in my Transform. I want to map "Name" to "First Name" in the next Transformation(Filter/Transform). How can I achieve that?

Best Answer

  • Sueann See
    Sueann See Experian Super Contributor
    Answer ✓


    1. For column X use Constant value then select Column Y. This way, you are populating X with the value of Y column.

    2. At a Transform step, you can hide/show the columns. Columns that are hidden will not be carried forward to the next step.

    3. You can use a Map To Target step to map to a target schema. Alternatively, you can do a simple rename at the Transform step.