Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to combine 2 fields in the load script into 1 field. Both of these fields has values.
Example: Field_A and Field_B has a value of 100 and i would like to create a field called Field_X.
something like this.
Field_A & Field_B as Field_X
Any input will be greatly appreciated!.
Frank
and if there is a chance that one of them might be null and you would still want them to be Summed together (like A = 100, B = Null() -> X = 100) then try this:
RangeSum(Field_A, Field_B) as Field_X or
Alt(Field_A, 0) + Alt(Field_B, 0) as Field_X
HTH
Best,
Sunny
load
Field_A,
Field_B,
Field_A & Field_B as Field_X,
....
from
.....
Load
Field_A,
Field_B,
Field_A & Field_B as Field_C
From ....
By combining you mean placing them next to each other? Like 100100 in your example?
If that's true your script should work Field_A & Field_B as Field_X. Is it not working?
Sunindia,
good catch.
No, i need Field_X as the sum of Field_A & Field_B.
A=100
B=100
X=200
then it should be Field_A + Field_B as Field_X
and if there is a chance that one of them might be null and you would still want them to be Summed together (like A = 100, B = Null() -> X = 100) then try this:
RangeSum(Field_A, Field_B) as Field_X or
Alt(Field_A, 0) + Alt(Field_B, 0) as Field_X
HTH
Best,
Sunny
RangeSum(Field_A, Field_B) as Field_X
Thank you All for the input!.
Sunindia and Manish - both of your answer works
RangeSum(Field_A, Field_B) as Field_X
No problem
I am glad that we were able to help.
Best,
Sunny