Hi PQ Gurus,
I have a tall order, which I know I would NEVER be able to figure out myself, and am hoping one of you experts could assist. I know the requirements are pretty extensive, but would appreciate ANY help in trying to figure this out.
I have a large data set (small sample below), and I want to have Power Query achieve the following:
Randomly select 5 "Chat_ID"s for every "Support Name", but assign it to a "TM_Name" that ISN'T the existing one. The new TM Name should be added to the "New_TM_Name" column. I also want to make sure that every New TM has a (fairly) equal number of Chat_IDs assigned to them.
Note: I realize the sample below won't have enough records to fully complete the above, so if more sample records are required, please let me know.
ANY help would be greatly appreciated!
Thank you in advance!
I have a tall order, which I know I would NEVER be able to figure out myself, and am hoping one of you experts could assist. I know the requirements are pretty extensive, but would appreciate ANY help in trying to figure this out.
I have a large data set (small sample below), and I want to have Power Query achieve the following:
Randomly select 5 "Chat_ID"s for every "Support Name", but assign it to a "TM_Name" that ISN'T the existing one. The new TM Name should be added to the "New_TM_Name" column. I also want to make sure that every New TM has a (fairly) equal number of Chat_IDs assigned to them.
Note: I realize the sample below won't have enough records to fully complete the above, so if more sample records are required, please let me know.
Support_Name | TM_Name | Chat_ID | Interaction_ID | Help_Reasons | Secondary_Reasons | Support_Summary | ID | Date | New_TM_Name |
Anik | Rhonda | 662977956 | 53865 | B | B | - | 3 | 2023-01-03 | |
Anik | Rhonda | 343873234 | 56068 | B | B | - | 4 | 2023-01-03 | |
Anik | Rhonda | 467336576 | 50617 | O | U | - | 5 | 2023-01-03 | |
Anik | Rhonda | 694584381 | 9664 | M | C | - | 6 | 2023-01-03 | |
Zara | Clayton | 54710737 | 4256 | O | H | - | 7 | 2023-01-03 | |
Juan | Lisa | 807249566 | 62201 | M | O | - | 8 | 2023-01-03 | |
Juan | Lisa | 807249566 | 62201 | M | O | - | 9 | 2023-01-03 | |
Zara | Clayton | 546871385 | 61283 | G | Q | - | 10 | 2023-01-03 | |
Juan | Lisa | 620484451 | 57343 | O | U | - | 11 | 2023-01-03 | |
Louise | Vivian | 43744844 | 45033 | 1 | S | - | 12 | 2023-01-03 | |
Louise | Vivian | 43744844 | na | A | H | - | 13 | 2023-01-03 | |
Zara | Clayton | 923651725 | 64922 | O | U | - | 14 | 2023-01-03 | |
Patrice | Jawad | 70008 | M | C | - | 15 | 2023-01-03 | ||
Juan | Lisa | 857946142 | 77427 | M | R | - | 16 | 2023-01-03 | |
A | Jawad | 59250 | B | B | - | 17 | 2023-01-03 | ||
Louise | Vivian | 573224497 | 70251 | M | O | - | 18 | 2023-01-03 | |
Louise | Vivian | 573224497 | 70251 | D | N | - | 19 | 2023-01-03 | |
Zara | Clayton | 375921396 | 69594 | G | U | - | 20 | 2023-01-03 | |
Justin | Rhonda | 341720163 | 84709 | M | C | - | 21 | 2023-01-03 | |
Zara | Clayton | 573896478 | 96765 | G | U | - | 22 | 2023-01-03 | |
Tim | Rhonda | 745096888 | 57806 | G | U | - | 23 | 2023-01-03 | |
Anik | Rhonda | 8956385 | - | M | R | - | 24 | 2023-01-03 | |
Richard | Tyler | 637547297 | 88071 | D | N | - | 25 | 2023-01-03 | |
Louise | Vivian | 573224497 | 70251 | M | C | - | 26 | 2023-01-03 | |
Sharon | Javier | 594284285 | 0 | T | T | - | 27 | 2023-01-03 | |
Nancy | Vivian | 172491051 | 72221 | B | B | - | 28 | 2023-01-03 | |
Rita | Javier | 948095098 | 95098 | M | R | - | 29 | 2023-01-03 | |
Melissa | Rhonda | 447198498 | 63288 | O | U | - | 30 | 2023-01-03 | |
A | Jawad | 97576 | B | B | - | 31 | 2023-01-03 | ||
Justin | Rhonda | 91329226 | 684 | O | U | - | 32 | 2023-01-03 | |
Juan | Lisa | 121617022 | 1004 | G | C | - | 33 | 2023-01-03 | |
Ginny | Javier | 808587838 | 2649 | B | B | - | 34 | 2023-01-03 | |
Julie | Lisa | 57376192 | 87943 | O | H | - | 35 | 2023-01-03 | |
kathleen | Gregory | 89336 | G | U | - | 36 | 2023-01-03 | ||
Nancy | Vivian | 441882064 | 81622 | B | B | - | 37 | 2023-01-03 | |
Tim | Rhonda | 226877514 | 63652 | G | U | - | 38 | 2023-01-03 | |
Vanessa | Lisa | 519160326 | 8575 | 1 | S | - | 39 | 2023-01-03 | |
Stacy | Tyler | 404601950 | 0 | B | B | - | 40 | 2023-01-03 | |
Patrice | Jawad | 72289 | 1 | S | - | 41 | 2023-01-03 | ||
Louise | Vivian | 43744844 | na | 1 | S | - | 42 | 2023-01-03 | |
Dan | Lisa | 58453804 | 9650 | V | C | - | 43 | 2023-01-03 | |
Richard | Tyler | 80151589 | 20718 | M | C | - | 44 | 2023-01-03 | |
Melissa | Rhonda | 78334347 | 95257 | O | U | - | 45 | 2023-01-03 | |
ChristineM | Lisa | 766697449 | 4401 | M | O | - | 46 | 2023-01-03 | |
Juan | Lisa | 900865002 | 22568 | B | B | - | 47 | 2023-01-03 | |
Zara | Clayton | 712408751 | 84141 | M | C | - | 48 | 2023-01-03 | |
Joseph | Jawad | 16946 | V | O | - | 49 | 2023-01-03 | ||
Cheryl | Lisa | 7442682 | 2188 | O | U | - | 50 | 2023-01-03 | |
Nancy | Vivian | 981167335 | 20587 | B | B | - | 51 | 2023-01-03 |
ANY help would be greatly appreciated!
Thank you in advance!