DSXchange

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.

How is this new question different from this question?

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

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

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

Hi,

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

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.

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