Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
What is the use of <> sign in following :
if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch
Thanks
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
<> refers to not equal sign
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
'<>' not equal sign .
Refer this link for more info Expressions
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"
Hi
'<>' refers to not equal sign
Hyi..
'<>' implies ' not equal to' or opposite of '='
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