How to populate previous row using transformer

[times29]

Hi,
Source date look like

Code: Select all

doc_num , doc_num_reject ,cost_sk ,order_sk ,doc_last_num
123          123               -1       -1             null

123                            -1       202            123

how can i compare two rows and populate doc_num_reject( -->123) for second row.

Code: Select all

doc_num , doc_num_reject, cost_sk ,order_sk ,doc_last_num
123          123               -1       -1         null

123       -->123               -1      202       123

[chulett]

So not actually populating the previous row but the current row with data from the previous row. That's just stage variables in a transformer. Since stage variables are evaluated top to bottom, you've always been able to hold on to any previous value from a row and leverage it in future rows.

[times29]

Can you please remove premium content from post as my membership has expired and i have not renewed it yet

[chulett]

Not sure there's a need for that. How familiar are you with stage variables? This is pretty basic 'group change detection' logic you would need to leverage. There are a number of examples that you could adapt for this, here is one.