Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Trying to create a column with multiple arguments

I'm looking to create a new column with several IF and OR arguments but there is only a max of 2 allowed. I have seen that || can be used, but I'm unsure of where to use it. I'm relatively new to Po...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    aha, try like:

    column = 
    SWTICH(
        TRUE(),
        [NBR] IN {6002, 7102, 7087}, "ON1",
        [NBR] IN {6063, 7101, 6081, 6080}, "AB",
        [NBR] IN {7103, 6097, 6098, 6093}, "ON2",
        [NBR] IN {6072, 6064}, "BC", 
        [NBR]=6083, "SK", 
        "unknown"
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

are you creating the column in LT table?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes I am