In The Row Normaliser plugin in type columun what to set in that column?
The Row Normaliser step in AutomationEdge is used to convert de-normalized data into normalized row-level data.
When configuring the Type column, you need to provide a string value that identifies or classifies each field being normalized. This value will be populated in the Type Field column of the output.
Consider the following product sales data:
| Month | A | B | C |
|---|---|---|---|
| 2003/01 | 0 | 5 | 17 |
| 2003/02 | 12 | 7 | 19 |
Row Normaliser configuration:
- Type Field:
Product
Fields Table:
-
Field Name: A → Type: A → New Field: Sales
-
Field Name: B → Type: B → New Field: Sales
-
Field Name: C → Type: C → New Field: Sales
Output:
| Month | Product | Sales |
|---|---|---|
| 2003/01 | A | 0 |
| 2003/01 | B | 5 |
| 2003/01 | C | 17 |
| 2003/02 | A | 12 |
| 2003/02 | B | 7 |
| 2003/02 | C | 19 |
Set the Type column with a meaningful identifier (such as product name).
This value helps identify which column the data came from after normalization.
The New Field stores the actual normalized values.
