logic required for increment field

hargun · Post by **hargun** » Wed Nov 06, 2013 8:43 am

hi,

i have extracting the data from DB2 and loading into oracle stage.

the out put i need is given below.

No	      AP BK_NO	VER	SHORT_NAME	      DS_LOAN_DESC
10000241	1	1	1	     CIT FINANCE LLC	 PARTIC01
10000241	1	1	1	     BMO            	 PARTIC02

if no=10000241 and shortname=CIT FINANCE LLC then i need PARTIC01

similary if no=10000241 and shortname=CIT FINANCE LLC then i need PARTIC02

from source i am getting the DS_LOAN_DESC=PARTIC which i need to change to PARTIC01 and PARTIC02.

please help me on this.

chulett · Post by **chulett** » Wed Nov 06, 2013 8:50 am

OK... that seems like a pretty straight-forward derivation to me. What have you tried? What issues are you seeing?

hargun · Post by **hargun** » Wed Nov 06, 2013 9:15 am

i have tried with stage variable

select_stats.DS_LOAN_DESC='PARTIC' =stgvar
stgvar+1 =stgvar2

then in derivation using

if select_stats.OBG_NO= '10000241' then stgvar1 else select_stats.DS_LOAN_DESC

but this giving me the same result that is 'PARTIC'.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 06, 2013 9:41 am

I'd envisage a double-nested If..Then..Else as the right way to solve this one.

chulett · Post by **chulett** » Wed Nov 06, 2013 10:28 am

Agreed... no stage variables needed. And you need to use concatenation, not math for this.

hargun · Post by **hargun** » Wed Nov 06, 2013 10:52 am

please check the if then else nested as per ray suggested

if select_stats.OBG_NO= '10000241' else if select_stats.DS_LOAN_DESC='PARTIC' then select_stats.DS_LOAN_DESC+1 else select_stats.DS_LOAN_DESC

chulett · Post by **chulett** » Wed Nov 06, 2013 11:27 am

Re-read my post.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 06, 2013 6:07 pm

You're missing the THEN clause of the first IF.