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..
stage variables
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
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
Re: stage variables
Hi,
Check this. Else you can do a search in the forum as this is discussed many times here..
Code: Select all
SV1:column1
SV2:If SV1=SV3 then 1 Else 0
SV3:SV1
Constraint::SV2=0