Forum Discussion
Magnus-CPH-DK
3 years agoHelper II
Problems with unpivoting multiple column value pairs
Hi everybody, I have a table with contracts which frequently undergo inspections. Each inspection can contain up two 3 types of suppliers, each with their own respective supplier ID. In the atta...
- 3 years ago
FYI that I was not able to modify your query as it references a file on your local drive. However, FYI that this YoutTube video covers how to handle this scenario. There is a file you can download too, if needed.
Faster Data Transformations with List/Record M Functions - YouTube
Pat
Magnus-CPH-DK
3 years agoHelper II
mahoneypat
3 years agoMicrosoft Employee
FYI that I was not able to modify your query as it references a file on your local drive. However, FYI that this YoutTube video covers how to handle this scenario. There is a file you can download too, if needed.
Faster Data Transformations with List/Record M Functions - YouTube
Pat