Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Specialsts,
How can I use the the function BITXOR in a Qlikview load script?
Is that possible?
Thanks,
Dennis.
I fixed it by creating a VB-function in the Module Editor.
And use that function in the script.
Thanks for your time.
Dennis.
Hi Dennis,
bitxor (and other bitwise operators) are all in the documentation so I imagine it's as simple as
bitxor(number1, number2)
The script editor may indicate an error but the script should still load.
Marcus
Thanks Marcus,
But I seems like it doesn't work.
It returns:
Error in expression:
BITXOR is not a valid function
Berekening:
LOAD *,
bitxor(num, num2) as Bin_num
I fixed it by creating a VB-function in the Module Editor.
And use that function in the script.
Thanks for your time.
Dennis.
Hi,
bitxor being an operator and not a function, another more straightforward approach could be:
LOAD *,
OP1 bitxor OP2 as OP1xorOP2
Inline [
OP1, OP2
0, 1
0, 1
1, 0
1, 1
2, 0
2, 1
2, 2
255, 1
255, 2
255, 4
255, 8
255, 16
255, 32
255, 64
255, 128
];
hope this helps
regards
Marco
to improve readability:
hope this helps
regards
Marco