topic Re: Create new fields combined two fields with condition in QlikView

Create new fields combined two fields with condition

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

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

];

Re: Create new fields combined two fields with condition

tresB — Wed, 18 Jul 2018 05:40:04 GMT

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

];