Transformer. Would like to hear some ideas.

[splayer]

I have a job with a transformer in the middle where rows are coming in. The first column is an integer column starting with 1. I would like to output integer value 1 for the first two rows, 2 for the next two rows, 3 for the next two rows and so on. I can use other stages as well if needed. Any ideas?

[chulett]

Stage variables and a mod() function comes to mind, that and the @INROWNUM system variable. And a single node.

[ray.wurlod]

Code: Select all

Int((InLink.TheInteger + 1) / 2)

[splayer]

Ray, can you please explain your solution a little?

For @INROWNUM=1 and 2, the key has to be 1.
For @INROWNUM=3 and 4, the key has to be 2 and so on.

Also, 2 is an example number. It could be some other number as well such as 5.
I am having a problem in getting equal number of rows for each key. The first set always has 1 less.

[ray.wurlod]

My solution does not involve @INROWNUM. If you use @INROWNUM it increments on each node, though that would work OK in a two node configuration using Round Robin partitioning if your data were sorted by the integer value to which you referred. But you described your requirement in terms of pairs of rows that include a sequencing integer (1,2,3,4,5,...), so my solution was based on that.

That you have an odd number of rows in your input data, but expect an even number of rows, is therefore curious. Are you trying to read column headings as a data row? Have you specified a partitioning algorithm? Can you guarantee that your source data are made up of pairs of rows?

[ray.wurlod]

Code: Select all

N                 1  2  3  4  5  6  7  8  9
Int(N+1)/2)       1  1  2  2  3  3  4  4  5