You can combine multiple columns together to map to one output column. When combining, you can:
- Specify the order in which the columns combine
- The separator used between the columns when combined - e.g. space, dash, tab, some string etc
- Combine the columns into a JSON structure - where each row will be represented as a key-value pair, where the key is the old column's name and value is the value of that old column in that row
See the API for more details of how to configure this and its functionality.
Currently, when combining, the column can only be combinined into an output column with a string or JSON data type.
- Combining numerical columns by aggregating their values using mathematical operations like summing, dividing, subtracting, multiplying, averaging or using equations!