Scenario Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field. This should be a numeric field indicating the sequence in which to concatenate the records. This field doesn’t not need to be consecutive. Second. The difference between lowest and highest line numbers should be a reasonably low number. In this example the max difference is 11, and it means that at the very maximum we would need to concatenate 11 text fields together. Step One Generate a driver file with MIN…