Forum Discussion
Order line SKU combinations
Can anyone assist with the following issue I've been stuck on for days, I have a table that has two columns: "Item Number (SKU)" and "Order Number". I need to generate a list of order combinations associated with a SKU and if that list also applies to another SKU generating a new row for each SKU order list combination. sample data below
| Item Number (SKU) | Order Number |
| AC12TAR6 | 6010071 |
| AC12TAR6 | 6010072 |
| AC12TAR6 | 6010973 |
| AC12TAR6 | 6034166 |
| AC12TAR6 | 6034168 |
| AC12TAR6 | 6034170 |
| AGG12B6 | 6027364 |
| AGG12B6 | 6029529 |
| AGG12B6 | 6029530 |
| AGG12B6 | 6032487 |
| AGG12B6 | 6042748 |
| BB3BF9 | 6018230 |
| BB3BF9 | 6038288 |
| BB3BF9 | 6038290 |
| BB4BC6 | 6024689 |
| BB4BC6 | 6043674 |
| BB4BC6 | 6043808 |
| BB4BF6 | 6010973 |
| BB4BF6 | 6011877 |
| BB4BF6 | 6013191 |
| BB4BF6 | 6024913 |
| BB4BF6 | 6025173 |
| BB4BF6 | 6025182 |
| BB4BF6 | 6029530 |
| BB4BF6 | 6029763 |
| BB4BF6 | 6032348 |
| BB4BF6 | 6034166 |
Expected output
| Item Number (SKU) | List |
| AC12TAR6 | 6010071; |
| AGG12B6 | 6010071; |
| BB4BC6 | 6010071; |
| AC12TAR6 | 6010072;6034170; |
| BB3BF9 | 6010072;6034170; |
| BB4BC6 | 6010072;6034170; |
| AC12TAR6 | 6010973;6034166;6034168; |
| AGG12B6 | 6010973;6034166;6034168; |
| BB3BF9 | 6010973;6034166;6034168; |
3 Replies
- lbendlin
Super User
I don't understand the rules behind your expected outcome. Can you please explain them again?
v-jianboli-msftCommunity Support
Hi Anonymous ,
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario? What is your rule to generate list? It seems that some SKUs have a list of expected outputs that contain order numbers which are not in the source table.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
