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]

Hi,

if I undestand right:

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

Regards.

[MK_QSL]

IF(Field1 = 'A' and Field2 = 'X', Field2) as NewField

[#4]

No what I had was right , I want Field2 Value to be dependent on Field1.

For Example

If(Category='Tennis',  then Activity='Sports' else Activity)

[#5]

No what I had was right , I want Field2 Value to be dependent on Field1.

For Example

If(Category='Tennis',  then Activity='Sports' else Activity)

[Anonymous]

Excuse me but I dont understand.

Is this?

If(Field1='Tennis', ' Sports' , Field2) as Field2

Or Field2 is a new field?

So is:

If(Field1='Tennis', ' Sports' , 'Other') as Field2

[daniel_kusiak]

If(Category='Tennis',  then Activity='Sports' else Activity)

IF(Field1 = 'A',Field2,Field2) as NewField

[Anonymous]

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

[MK_QSL]

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

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

[Anonymous]

if you still have an issue post us sample data in excel sheet