DSXchange

[quote="kcbland"]I would use a SEQ stage to read file 1 and go to a XFM and leave the data in the column position it's in, but add a third column with a derivation of "". I would add another SEQ stage to read file 2 and go to a XFM and map the data into the third column created j...

[quote="Luciana"]Use stage variables on sorted data. Ex.: varEmp (@Null) := RowProcGetPreviousValue(ENTRADA.id) varSeq (0) := if ENTRADA.id = varEmp then varSeq +1 else 1 -------------------------------------------------------- Target id_key := ENTRADA.id : varSeq[/quote] -----------------...