Stage Variable Declare

laknar · Post by **laknar** » Fri Dec 05, 2008 4:11 am

Number amount currency Code CustID Address
123456 10.00 22 21 123 London
123456 10.00 22 11 234 Chennai

Address Table

CustID Address
123 London
234 Chennai

I have to findout duplicate based on Number ,amount,currency columns
and if code starts with 2 and populate corresponding address.

Else if code column start with 1 then populate code starts with 2 Address value.

The above is exact logic im trying.

Where as Address values are in different table and Im taking as lookupset in a job.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 05, 2008 4:39 am

How is this new question different from this question?

Do you have any idea how annoying being asked the same question multiple times is?

laknar · Post by **laknar** » Sat Dec 06, 2008 4:31 am

Hi,

Can you please explain the below functionality,how it works.

if CustID[1,1] = '1' then DSLink1.Address else StageVar1

simply populate your output column with StageVar1

mdbatra · Post by **mdbatra** » Sat Dec 06, 2008 4:36 am

U can get to know the functionality if you carefully observe the output of your job by changing the arguments([1,2], [1,4] ...)

laknar · Post by **laknar** » Sat Dec 06, 2008 5:26 am

Hi,

Is it need to assign any Initial Value for the stage variable.

mdbatra · Post by **mdbatra** » Sat Dec 06, 2008 5:35 am

It is obtain a substring of the input column.
Further,the expression you are calculating can be given as a constraint,Stage variable's derivation or an output column derivation.

mdbatra · Post by **mdbatra** » Sat Dec 06, 2008 5:36 am

Infact, not just the input ,any column on which you are operating.