Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi alli,
this is my scenario
column A ! Column B ! Final
False False False
False True True
True False True
True True True
I need suggestion to get final column
As pointed out by Eduardo this should be OR instead of AND
The final table is a Boolean AND OR of Column A and Column B.
If these fields hold correct True (-1) and False (0) values, then you can use the expression
= columnA OR columnB
Hi,
another solution using dual values could be:
table1:
LOAD Pick(Wildmatch(A,'false','true'),Dual('False',0),Dual('True',-1)) as A,
Pick(Wildmatch(B,'false','true'),Dual('False',0),Dual('True',-1)) as B
INLINE [
A, B
False, False
False, True
True, False
True, True
];
hope this helps
regards
Marco