Create new fields combined two fields with condition

[karan_kn]

For the below table add a Newfield which is B_ID if present but the C_ID, if B_ID not present, add a symbol like a '-' to see the difference. Refer the screenshot for better understanding.

LOAD * INLINE [

    A_ID, B_ID, C_ID

    1, 123, 1111

    2, 234, 2222

    3, , 3333

    4, , 4444

    5, 345, 5555

];

[tresB · Accepted solution]

Try like:

Load

     *,

     If(Len(trim(B_ID))>0, B_ID, '-'&C_ID) as New_ID

;

LOAD * INLINE [

    A_ID, B_ID, C_ID

    1, 123, 1111

    2, 234, 2222

    3, , 3333

    4, , 4444

    5, 345, 5555

];