Map list: Transform every item in a list

What it does:

Applies a transformation function to each item in the list and returns a new list with the transformed values.

Where it works:

  • Comma-separated list
  • JSON list

Business Use Case & Example:

  • Adding new prefix for employee ids before loading into a master database:
image.png

This is perfect for standardizing formats, cleaning up inputs, or preparing data for display.

Next up: MapPath – targeting specific fields in JSON documents.

Back to main post