Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
The data in the left side of the table is what i have, i want to remove "sections" that are "0", however there are "cat" with all "section" equals to "0", and i would like to keep this "cat" as shown in the right side of the table.
cat | section | T/F | cat | section | T/F | |
1 | A | 1 | 1 | A | 1 | |
1 | B | 0 | 2 | D | 1 | |
1 | C | 0 | 3 | null | null | |
1 | D | 0 | 4 | null | null | |
2 | A | 0 | 5 | null | null | |
2 | B | 0 | 6 | null | null | |
2 | C | 0 | 7 | any of the letter | 0 | |
2 | D | 1 | ||||
3 | null | null | ||||
4 | null | null | ||||
5 | null | null | ||||
6 | null | null | ||||
7 | A | 0 | ||||
7 | B | 0 | ||||
7 | C | 0 | ||||
7 | D | 0 |
Solved! Go to Solution.