How to use compare stage?

[tjhaosse]

Dear All

I don't know how to define output column metadata for compare stage.

for example :
first set -> id,colA,colB,colC
second set -> id,colA,colB,colC

I wanted to use compare stage to comapre first set and second set, but I don't know how to define the output metadata in compare stage.

Can anyone teach me?

Thanks a lot.

[miwinter]

Compare adds new fields to indicate the result of the compare, so the best way is to check to turn on runtime column propagation on your output link columns tab.