Help Centre

Clip From Column
Clip From Column is a templated script operation which enables all data to the right or left of any given column to be removed.
Usage
Insert the name of the final (rightmost) column that is required in the output – all columns to the right of this column will be removed from the output.
clipAfterColumn:
"<insert final column name>"

Alternatively, insert the name of the first (leftmost) column that is required in the output – all columns to the left of this column will be removed from the output.
clipFromColumn:
"<insert first column name>"
Example
In the table below some notes on ‘LOB types’ have been added to the right of the data we require.
ID
LOB
Amount
LOB types
1
car
100
Car insurance
2
life
1000
Life insurance
3
car
100
 
Select ‘Amount’ as the final column name:
clipAfterColumn:
"Amount"

This results in:
ID
LOB
Amount
1
car
100
2
life
1000
3
car
100


Alternatively, to remove all columns to the left of the selected column:
clipFromColumn:
"Amount"

This results in:
Amount
LOB types
100
Car insurance
1000
Life insurance
100