DSXchange

It can't be done using a range lookup. As Ray mentioned, it can be done using Sort and transformer, followed by stage variables to remember the previous value. The overlapping can happen in 13 possible ways (Allen's interval algebra explains this). The 13 here is an exhaustive set. So, use stage var...

Before computing the checksum, the Checksum stage arranges the columns in the alphabetical order of column names (irrespective of the order they appear in your input column tab). I have tried and tested a couple of possibilities and there seem to be no option to rearrange the column order in which c...