true or false

[raadwiptec]

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

[Colin-Albert]

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

[MarcoWedel]

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