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.
1
car
100
life = life insurance
2
life
1000
car = car insurance
Select ‘Amount’ as the final column name:
clipAfterColumn: "amount"
This results in:
Clip from column
If we only know the name of the first uninteresting column, we can use
clipFromColumn: "LOB"
This results in: