Static lookup

Description

The Static Lookup activity allows you to transform values in a data column based on static rules. You can use either:

A Key-Value Mapping to convert specific values (e.g., A → Excellent, B → Good), or
A Range Mapping to assign labels based on numeric thresholds (e.g., 0–50 → Low, 51–100 → High).

The transformation result can be placed in the same column or in a new one. This is particularly useful for standardizing values, labeling data, or enriching tabular records with human-readable outputs.

Use case: You can clean up coded fields in survey results or product grades by mapping them to readable formats, or assign data buckets like “Low/Medium/High” to a numeric score column.

Input

Data – Required
Tabular data with at least one column containing values to be mapped.

Output

Output Type	Format	Description
Data	Tabular	Transformed data with updated or additional mapped columns

Configuration Fields

Field Name	Description
Column	Column to which the mapping should be applied.
Create New Column	Whether the result should go in a new column (`true`) or replace the original column (`false`).
New Column Name	Required if `Create New Column` is enabled. Name of the output column.
Include Original	Whether to retain the original data columns in the final output.
Use Range Lookup	If enabled, uses numeric ranges instead of key-value pairs.
Range Lookup Items	Required when using range lookup. List of `{Start, End, Value}` objects.
Lookup Map	Required when not using range lookup. Dictionary of `original value → mapped value`.

Sample Input

ID	Grade	Score
1	A	85
2	B	67
3	C	45
4	D	25

Sample Configuration – Key-Value Mapping

Field	Value
Column	Grade
Create New Column	true
New Column Name	Grade_Full
Include Original	true
Use Range Lookup	false
Lookup Map	{ A: “Excellent”, B: “Good”, C: “Average”, D: “Poor” }

Output

ID	Grade	Grade_Full
1	A	Excellent
2	B	Good
3	C	Average
4	D	Poor

Sample Configuration – Range Mapping

Field	Value
Column	Score
Create New Column	true
New Column Name	Score_Bucket
Include Original	true
Use Range Lookup	true
Range Lookup Items	[{Start: 0, End: 50, Value: “Low”}, {Start: 51, End: 75, Value: “Medium”}, {Start: 76, End: 100, Value: “High”}]

Output

ID	Score	Score_Bucket
1	85	High
2	67	Medium
3	45	Low
4	25	Low