What does '<>'implies ??

[nikhilgarg]

Hey,

What is the use of <> sign in following :

if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch

Thanks

[Anonymous]

<> refers to not equal sign

[#3 · Accepted solution]

Hi Nikhil,

<> sign is equivalent to 'not equal'.

if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch

Here if the First 3 Characters of BranchCode is not equal to MergeCode then value of the field MergeCode will get stored in NewBranch else First 3 Characters of Branch Code will get stored in NewBranch .

Hope, it hepls you.

Regards,

Ankur

[Anonymous]

'<>' not equal sign .

Refer this link for more info Expressions

[rubenmarin]

As said above, it's the operator for 'not equal', in this case I don't think is needed in the expression you post, you can directly use:

MergeCode as NewBranch

In your expression if "left(BranchCode,3)" is not equal to "MergeCode" then gets "MergeCode"

If it's equal it takes "left(BranchCode,3)" but if it's equal to "MergeCode" is the same to get "MergeCode"

[Anonymous]

Hi

'<>' refers to not equal sign

[alkesh_sharma]

Hyi..

'<>' implies ' not equal to' or opposite of '='

[its_anandrjs]

Hi,

In the expression  if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch

in this line if(left(BranchCode,3)<>MergeCode,MergeCode if condition true you fetch the MergeCode data where left(BranchCode,3)<>MergeCode means it is other rows.

And if false you fetch left(BranchCode,3).

And here <> means not equals.

Regards

Anand