If Statement Issue

[#1]

I am trying to use an If Statement which should change the Value of another field. For Example

If(Field1='A', Field2='X',Field2) as New_Field.

How can I accomplish this

[Anonymous]

i think Manish answered your question. Let us know if that does not fix your problem

[Anonymous]

If(Category = 'Tennis', 'Sports', Activity) as Activity

[#4]

Thanx for ur help, but here is the sample  data

LOB	ISSUECODE
X	N
Y	N
Z	N
C	R

What I want is

If (LOB='Z' then change ISSUECODE ='R',ISSUECODE)

[#5]

Thanx for ur help, but here is the sample  data

LOB	ISSUECODE
X	N
Y	N
Z	N
C	R

What I want is

If (LOB='Z' then change ISSUECODE ='R',ISSUECODE)

[#6]

Thanx for ur help, but here is the sample  data

LOB	ISSUECODE
X	N
Y	N
Z	N
C	R

What I want is

If (LOB='Z' then change ISSUECODE ='R',ISSUECODE)

[MK_QSL]

If (LOB='Z','R',ISSUECODE) as ISSUECODE

[#8]

Still not working

here is the current Expression

iF(ISSUE0CODE_Combo='N' OR(  ISSUE0CODE_Combo='M' AND MANUAL_CODE_DISTRIBUTION='NB') ,'N',

iF(ISSUE0CODE_Combo='R' OR (  ISSUE0CODE_Combo='M' AND MANUAL_CODE_DISTRIBUTION='RB') OR ISSUE0CODE_Combo='PRF' ,'R',

If(LOB='PRF','R',NULL()))) AS IssueCode_Current,

sample data

LOB   ISSUECODE  ISSUECODE_COMBO

A               R

PRF           N                       PRF

[sasiparupudi1]

Hi

You can only achieve this sort of if condition if you manually iterate through the table records and it is not possible in the preceding loads. please see the attachement. Hope this helps.

[sasiparupudi1]

Hi

Did you find your answer?

Sasi

[kavita25]

PFA

Hope it helps you.

Regards,

Kavita