Help Centre

Clip After Column
Clip after column is a templated script operation which enables all data to the right of any given column to be removed.
Usage
Insert the name of the 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>"


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
life = life insurance
2
life
1000
car = car 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


Clip from column
If we only know the name of the first uninteresting column, we can use
clipFromColumn: "LOB"


This results in:
ID
1
2
3