Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 [Sub Category] = "Boxing" THEN "Boxing "
ELSEIF [Sub Category] = "Karate" THEN "Karate"
END
ELSEIF [Category] = "Sports" THEN "Sports"
ELSEIF [Category] = "Winter Sports" THEN
IF [Sub Category] = "Snowboarding" THEN "Snowboarding"
ELSEIF [Sub Category] = "Skiing" THEN "Skiing"
END
I tried using Switch function and had no luck, does anyone has any suggestions?
Thank you
Solved! Go to Solution.
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"
)
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"
)
Hi @Anonymous ,
You can use below code:-
Measure =
IF (
[Category] = "Martial Arts ",
IF (
[Sub Category] = "Boxing",
"Boxing",
IF (
[Sub Category] = "Karate",
"Karate",
IF (
[Category] = "Sports",
"Sports",
IF (
[Category] = "Winter Sports",
IF (
[Sub Category] = "Snowboarding",
"Snowboarding",
IF ( [Sub Category] = "Skiing", "Skiing" )
)
)
)
)
)
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
53 | |
35 | |
20 | |
15 | |
14 |
User | Count |
---|---|
94 | |
76 | |
36 | |
22 | |
18 |