IF OR syntax in Data Manager

[snowman]

Hi there,

In Data Manager I am not sure how to put "IF" and "OR" together:

In this statement, it works:

   If(wi1 = 'R', 'R', 'L')

But when I put Or inside the IF function, I got the error of Missing right parenthesis:

   If(wi1 = 'R' or wi2 = 'R', 'R', 'L')

wi1 and wi2 are data fields with either 'R' or 'L'

Wonder what should be the appropriate syntax as the parenthesis should be OK.

Thanks

[EliGohar · Accepted solution]

@snowman 

Your syntax works fine for me:

Table:
LOAD * INLINE [
    wi1, wi2
    'R','L'
    'R','R'
    'L','R'
    'L','L'
];


Table2:
Load *,  If(wi1 = 'R' or wi2 = 'R', 'R', 'L') as condition
Resident Table;

Drop table Table;

[snowman]

Hi @EliGohar ,

Thanks, and yes when I switched to Data Load Editor after struggling in the Data Manager for hours, the script is OK. Just wonder if there is any limitation in the Data Manager.

Admittedly Data Manager is more easy to use, and since once it is unlocked I cannot go back to Data Manager from the Data Load Editor, I hope I can do all of the data loading tasks there.