Dynamic fieldname changes
I would like to append a variable (or string constant) to the end of fieldnames from a text file input. From the example below, the desired outcome would have each field appended with "_input".
fieldname (before) (after)
RecordID RecordID_input
RecordType RecordType_input
SequenceNumber SequenceNumber_input
The file I'm working with contains several hundred fields so doing this manually would be very time consuming. Is there a 3.2 Kettle transform that performs this function? If not, I would greatly appreciate an alternative to my problem.
TIA
Gerald Duncan