DSXchange

Posted: **Fri Apr 13, 2007 11:21 am**

Hi,

I have a condition where i need to apply a constraint to one of my link. I have set of records ordered by column1. I want to check whether the current column1<>previous column1. I want to use this as a constraint to my output link.

can i make use of this in stage variables.

i used them as follows:
in stage variables
---------------------------
stagevar1=inputlink.column1
stagevar2=stagevar1

constraint
----------------------
stagevar2<>stagevar1

column derivation
------------------------
outputlink.column1=inputlink.column1

need help guyzzz..

Posted: **Fri Apr 13, 2007 11:43 am**

Code: Select all

stgvar1:
if  column1 <> stgvar2 then 1 else 0
stgvar2:
column1

pass all of those for which stgvar1 = 1. before the transformer make sure to sort data on column 1

Posted: **Fri Apr 13, 2007 1:34 pm**

Hi,

Code: Select all

 SV1:column1
 SV2:If SV1=SV3 then 1 Else 0
 SV3:SV1

 Constraint::SV2=0

Check this. Else you can do a search in the forum as this is discussed many times here..

Posted: **Fri Apr 13, 2007 3:41 pm**

Thnxx a lot folks....
It works now.....

DSXchange

stage variables

stage variables

Re: stage variables