Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I think I've finally got a handle on Joins....
Spoiler
Spoiler
Process:
- Join data on PN
- Union left and join outputs
- Summary to calculate Total Prior APV (for calculating proportions)
- Sort by PN then by Prior APV (desc) to get order correct for Split field
- Join threads on PN
- Calculate proportion of each supplier against Prior APV
- Generate data for Split field
- Aggregate data and concatenate Split field (group by PN)
- Remove "," and "-" from Split + Ensure Null records as required
- Remove Proportion field
- Join data on PN
- Union left and join outputs
- Summary to calculate Total Prior APV (for calculating proportions)
- Sort by PN then by Prior APV (desc) to get order correct for Split field
- Join threads on PN
- Calculate proportion of each supplier against Prior APV
- Generate data for Split field
- Aggregate data and concatenate Split field (group by PN)
- Remove "," and "-" from Split + Ensure Null records as required
- Remove Proportion field
Fun challenge. This was the first time I had a use for using concatenate within the summary tool.
