Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Nested IF Question?

Hello All, I need some assistance with writing Nested If statement, I am trying to create a new column with the following if statement.   IF      [Category] = "Martial Arts "         THEN IF      ...
If statements
Nested IF
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I think SWITCH is a good idea.

     

    SWITCH (
    TRUE (),
    [Category] = "Martial Arts " && [Sub Category] = "Boxing", "Boxing",
    [Category] = "Martial Arts " && [Sub Category] = "Karate", "Karate",
    [Category] = "Sports", "Sports",
    [Category] = "Winter Sports" && [Sub Category] = "Snowboarding", "Snowboarding",
    [Category] = "Winter Sports" && [Sub Category] = "Skiing", "Skiing"
)
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I think SWITCH is a good idea.

 

SWITCH (
    TRUE (),
    [Category] = "Martial Arts " && [Sub Category] = "Boxing", "Boxing",
    [Category] = "Martial Arts " && [Sub Category] = "Karate", "Karate",
    [Category] = "Sports", "Sports",
    [Category] = "Winter Sports" && [Sub Category] = "Snowboarding", "Snowboarding",
    [Category] = "Winter Sports" && [Sub Category] = "Skiing", "Skiing"
)