DSXchange

hi

can any body sugg me how do romoveduplecate in transformar stage useing stage varible


regards
sure

2 Stage Variables: constraint "svDuplicate=0"

Or, exactly the same but my preference would be:
Constraint "Not(svDuplicate)"

Craig, I agree with you - I would program it that way but expanded the logic to make the statement more understandable.

You can use the following logic to remove duplicates using the Transformer Stage, however for that you need to have data sorted.

Before using the transformer Stage, use Sort Stage to sort the data.

In Transformer Stage, take the

FirstRecordVar=SecondRecordVar
IncomingLnk.Value=FirstRecordVar

Then in constraint you can put constraint like

FirstRecordVar<>SecondRecordVar

This will ensure that duplicates records are not passed to the next stage.

Hope this helps !

ArndW wrote:Craig, I agree with you - I would program it that way but expanded the logic to make the statement more understandable.

Of course and I figured as much... just couldn't resist the perfect setup.

mk_ds09 wrote:You can use the following logic to remove duplicates using the Transformer Stage, however for that you need to have data sorted.

Before using the transformer Stage, use Sort Stage to sort the data.

In Transformer Stage, take the

FirstRecordVar=SecondRecordVar
IncomingLnk.Value=FirstRecordVar

Then in constraint you can put constraint like

FirstRecordVar<>SecondRecordVar

This will ensure that duplicates records are not passed to the next stage.

Hope this helps !

Hi Sorry to interrupt but how do you achieve :

FirstRecordVar=SecondRecordVar
?

What exact syntax is used for the same?

sureshbabu wrote:hi

can any body sugg me how do romoveduplecate in transformar stage useing stage varible


regards
sure

Why not just use the de-duplicate stage?