Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need your help.
How to transform the following table:
Name | Course1 | Course 2 | Course 3|
A | YES | YES | NO |
B | NO | NO | YES |
C | NO | YES | NO |
In to :
Name | Course | mandatory
A | Course1 | YES
A | Course2 | YES
A | Course 3 | NO
B | Course 1 | NO
B | Course 2 | NO
B | Course 3 | YES
C | Course 1 | NO
C | Course2 | YES
C | Course 3 | NO
Or
Name | Course | mandatory
A | Course1 | YES
A | Course2 | YES
B | Course 3 | YES
C | Course2 | YES
Or
Name | Course |
A | Course1 |
A | Course2 |
B | Course 3 |
C | Course2 |
Many thanks for your help
Solved! Go to Solution.
Many thanks..... so easy and clear. Awesome
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |