Discussion Board for collaboration on QlikView Scripting.
Hi I have a script like below, how do I get to the expected result? Tried join but didn't work. Thank you!
LOAD * INLINE [
A, B, C
A, B, C, D
1, 2, 3, 4
Go to Solution.
So you want to join a 3 with a null. That's not going to happen. 3 will never be null.
Try joining without C:
LOAD A, B, C as X, D INLINE [
LOAD A, B, If(Len(Trim(C))=0,X,C) as C, D
DROP TABLE Temp;
You can also try this:
B, C as E;
If(Len(Trim(C)) = 0, E, C) as C,
DROP Table A;
Thank you both! Both are correct, too bad the system only allowed me to mark one...