New field name in field

[wllmdjngh]

Hi,
I would like to rename or pass value to a field whose name is inside an other field.
Example:
field_value = “value”
field_name = “name_for_value”
I would like to create a field which is name_of_value with the value contained in field_value which would get the end result as:
name_of_value = “value”

Is this even possible as a step?

Would appreciate any help.
Thanks

[AETrainings]

@wllmdjngh

Hi,
I would like to rename or pass value to a field whose name is inside an other field.
Example:
field_value = “value”
field_name = “name_for_value”
I would like to create a field which is name_of_value with the value contained in field_value which would get the end result as:
name_of_value = “value”

Is this even possible as a step?

Yes, this is possible in Process Studio

Using the “Row Denormalizer” Step (Native Step)

If your input rows contain key-value pairs (e.g., Row 1 has field_name = "name_for_value" and field_value = "value") and you want to turn those key values into actual column headers in your data stream, use the Row Denormalizer step.

1. Drag the Row Denormalizer step onto your canvas.
2. Set The key field to field_name.
3. In the Target fields table at the bottom:
   • Target fieldname: Enter your desired output field name (e.g., name_for_value).
   • Value fieldname: Select field_value.
   • Key value: Enter the exact string matched in field_name (e.g., name_for_value).
   • Type: Select String.

Result: The step pivots the row so that a new column named name_for_value is generated containing "value"