Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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
];
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
];