community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data sorting and assignment

AbhijeetChib
8 - Asteroid
‎01-11-2024 08:08 AM

Good Day I 

 

I have a requirement where there are 2 columns. 

1. Duplicate group 

2. Primary 

 

Duplicate group values are in pairs and are assigned to Primary. 

For example, duplicate group 207964 is assigned to Res A and Res B. 

207964Res A
207964Res B

 

I need to ensure that the pairs are assigned to only 1 resource. Expected output is below 

207964Res B
207964Res B

 

OR 

 

207964Res A
207964Res A

 

The catch is - Res A, Res B, Res C and Res D should be allocated equal number of records between them and their duplicate groups need to be the same. 

 

Thanks for any ideas. I have attached the data set 

 

Duplicate GroupPrimary
207964Res A
207964Res B
207965Res C
207965Res D
207966Res A
207966Res B
207967Res C
207967Res D
207968Res A
207968Res C
207970Res B
207970Res D
207971Res A
207971Res B
207972Res C
207972Res D
207973Res A
207973Res B
207974Res C
207974Res D
207975Res A
207975Res B
207976Res C
207976Res D
207977Res A
207977Res B
207978Res C
207978Res D
207979Res A
207979Res B
207980Res C
207980Res D
207981Res A
207981Res B
207982Res C
207982Res D
207983Res A
207983Res B
207984Res C
207984Res D
207985Res A
207985Res B
207986Res C
207986Res D
207987Res A
207987Res B
207988Res C
207988Res A
207989Res D
207989Res B
207990Res C
207990Res D
207991Res A
207991Res B
207992Res C
207992Res D
207993Res A
207993Res B
207994Res C
207994Res D
207995Res A
207995Res B
207996Res C
207996Res D
207997Res A
207997Res B
207998Res C
207998Res A
207999Res D
207999Res B
208000Res C
208000Res D
208001Res A
208001Res B
208002Res C
208002Res A
208003Res D
208003Res B
208004Res C
208004Res D
208005Res A
208005Res B
208006Res C
208006Res D
208007Res A
208007Res B
208008Res C
208008Res D
208009Res A
208009Res B
208010Res C
208010Res D
208011Res A
208011Res B
208012Res C
208012Res A
208013Res D
208013Res B
208014Res C
208014Res D
208016Res A
208016Res B
208017Res C
208017Res D
208018Res A
208018Res B
208019Res C
208019Res D
208020Res A
208020Res B
208021Res C
208021Res D
208022Res A
208022Res B
208023Res C
208023Res D
208024Res A
208024Res B
208025Res C
208025Res D
208026Res A
208026Res B
208027Res C
208027Res D
208028Res A
208028Res B
208029Res C
208029Res D
208030Res A
208030Res B
208031Res C
208031Res D
208032Res A
208032Res B
208033Res C
208033Res D
208034Res A
208034Res B
208035Res C
208035Res D
208036Res A
208036Res B
208037Res C
208037Res D
208038Res A
208038Res B
208039Res C
208039Res D
208040Res A
208040Res B
208041Res C
208041Res A
208042Res D
208042Res B
208043Res C
208043Res D
208044Res A
208044Res B
208045Res C
208045Res D
208046Res A
208046Res B
208047Res C
208047Res D
208048Res A
208048Res B
208049Res C
208049Res D
208050Res A
208050Res B
208051Res C
208051Res D
208052Res A
208052Res B
208053Res C
208053Res D
208054Res A
208054Res B
208055Res C
208055Res D
208056Res A
208056Res B
208057Res C
208057Res D
208058Res A
208058Res B
208059Res C
208059Res D
208060Res A
208060Res B
208061Res C
208061Res D
208062Res A
208062Res B
208063Res C
208063Res D
208064Res A
208064Res C
208065Res B
208065Res D
208066Res A
208066Res B
208067Res C
208067Res A
208068Res D
208068Res B
208069Res C
208069Res D
208071Res A
208071Res B
208072Res C
208072Res D
208073Res A
208073Res C
208074Res B
208074Res D
208075Res A
208075Res B
208076Res C
208076Res D
208077Res A
208077Res B
208078Res C
208078Res D
208079Res A
208079Res B
208080Res C
208080Res D
208081Res A
208081Res B
208082Res C
208082Res D
208083Res A
208083Res B
208084Res C
208084Res D
208085Res A
208085Res B
208086Res C
208086Res D
208087Res A
208087Res B
208088Res C
208088Res D
208089Res A
208089Res B
208090Res C
208090Res D
208091Res A
208091Res B
208092Res C
208092Res D
208093Res A
208093Res B
208094Res C
208094Res D
208095Res A
208095Res B
208096Res C
208096Res D
208097Res A
208097Res B
208098Res C
208098Res D
208099Res A
208099Res B
208100Res C
208100Res D
208101Res A
208101Res B
208102Res C
208102Res D
208103Res A
208103Res B
208104Res C
208104Res D
208105Res A
208105Res B
208106Res C
208106Res A
208107Res D
208107Res B
208108Res C
208108Res D
208109Res A
208109Res B
208110Res C
208110Res D
208111Res A
208111Res B
208112Res C
208112Res D
208113Res A
208113Res B
208114Res C
208114Res D
208115Res A
208115Res B
208117Res C
208117Res D
208118Res A
208118Res B
208119Res C
208119Res D
208120Res A
208120Res B
208121Res C
208121Res D
208122Res A
208122Res B
208123Res C
208123Res D
208124Res A
208124Res B
208125Res C
208125Res D
208126Res A
208126Res B
208127Res C
208127Res D
208128Res A
208128Res B
208129Res C
208129Res D
208130Res A
208130Res B
208131Res C
208131Res D
208132Res A
208132Res B
208133Res C
208133Res D
208134Res A
208134Res B
208135Res C
208135Res D
208136Res A
208136Res B
208137Res C
208137Res D
208138Res A
208138Res B
208139Res C
208139Res D
208140Res A
208140Res B
208141Res C
208141Res D
208142Res A
208142Res B
208143Res C
208143Res A
208144Res D
208144Res B
208145Res C
208145Res D
208146Res A
208146Res B
208147Res C
208147Res D
208148Res A
208148Res B
208149Res C
208149Res D
208150Res A
208150Res B
208151Res C
208151Res D
208152Res A
208152Res B
208153Res C
208153Res D
208154Res A
208154Res B
208155Res C
208155Res D
208156Res A
208156Res B
208157Res C
208157Res D
208158Res A
208158Res B
208159Res C
208159Res D
208160Res A
208160Res C
208161Res B
208161Res D
208162Res A
208162Res B
208163Res C
208163Res D
208164Res A
208164Res B
208165Res C
208165Res D
208166Res A
208166Res B
208167Res C
208167Res D
208168Res A
208168Res B
208169Res C
208169Res D
208170Res A
208170Res B
208171Res C
208171Res D
208172Res A
208172Res B
208173Res C
208173Res D
208174Res A
208174Res B
208175Res C
208175Res D
208176Res A
208176Res B
208177Res C
208177Res D
208178Res A
208178Res C
208179Res B
208179Res D
208180Res A
208180Res B
208181Res C
208181Res D
208182Res A
208182Res B
208183Res C
208183Res D
208184Res A
208184Res C
208185Res B
208185Res D
208186Res A
208186Res B
208187Res C
208187Res D
208188Res A
208188Res B
208189Res C
208189Res D
208190Res A
208190Res B
208191Res C
208191Res D
208192Res A
208192Res B
208193Res C
208193Res D
208194Res A
208194Res B
208195Res C
208195Res D
208196Res A
208196Res B
208197Res C
208197Res D
208198Res A
208198Res B
208199Res C
208199Res D
208200Res A
208200Res B
208201Res C
208201Res D
208202Res A
208202Res B
208203Res C
208203Res D
208204Res A
208204Res B
208205Res C
208205Res D
208206Res A
208206Res B
208207Res C
208207Res D
208208Res A
208208Res B
208209Res C
208209Res D
208210Res A
208210Res B
208211Res C
208211Res D
208212Res A
208212Res B
208213Res C
208213Res D
208214Res A
208214Res B
208215Res C
208215Res D
208216Res A
208216Res B
208217Res C
208217Res D
208218Res A
208218Res B
208219Res C
208219Res D
208220Res A
208220Res B
208221Res C
208221Res D
208222Res A
208222Res B
208223Res C
208223Res D
208224Res A
208224Res B
208225Res C
208225Res D
208226Res A
208226Res B
208227Res C
208227Res D
208228Res A
208228Res B
208229Res C
208229Res D
208230Res A
208230Res B
208231Res C
208231Res D
208232Res A
208232Res B
208233Res C
208233Res D
208234Res A
208234Res B
208235Res C
208235Res D
208236Res A
208236Res B
208237Res C
208237Res D
208238Res A
208238Res B
208239Res C
208239Res D
208240Res A
208240Res B
208241Res C
208241Res D
208242Res A
208242Res B
208243Res C
208243Res D
208244Res A
208244Res B
208245Res C
208245Res D
208246Res A
208246Res B
208247Res C
208247Res D
208248Res A
208248Res B
208249Res C
208249Res D
208250Res A
208250Res B
208251Res C
208251Res D
208252Res A
208252Res B
208253Res C
208253Res D
208254Res A
208254Res B
208255Res C
208255Res D
208256Res A
208256Res B
208257Res C
208257Res D
208258Res A
208258Res B
208259Res C
208259Res D
208260Res A
208260Res B
208261Res C
208261Res D
208262Res A
208262Res B
208263Res C
208263Res D
208264Res A
208264Res B
208265Res C
208265Res D
208266Res A
208266Res B
208267Res C
208267Res D
208268Res A
208268Res B
208269Res C
208269Res D
208270Res A
208270Res B
208271Res C
208271Res A
208272Res D
208272Res B
208273Res C
208273Res D
208274Res A
208274Res B
208275Res C
208275Res A
208276Res D
208276Res B
208277Res C
208277Res D
208278Res A
208278Res B
208279Res C
208279Res D
208280Res A
208280Res B
208281Res C
208281Res D
208282Res A
208282Res B
208283Res C
208283Res D
208284Res A
208284Res B
208285Res C
208285Res D
208286Res A
208286Res C
208287Res B
208287Res D
208288Res A
208288Res B
208289Res C
208289Res D
208290Res A
208290Res B
208291Res C
208291Res D
208292Res A
208292Res B
208293Res C
208293Res D
208294Res A
208294Res B
208295Res C
208295Res D
208296Res A
208296Res B
208297Res C
208297Res D
208298Res A
208298Res B
208299Res C
208299Res D
208300Res A
208300Res B
208301Res C
208301Res D
208302Res A
208302Res B
208303Res C
208303Res D
208304Res A
208304Res B
208305Res C
208305Res D
208306Res A
208306Res C
208307Res B
208307Res D
208308Res A
208308Res B
208309Res C
208309Res D
208310Res A
208310Res B
208311Res C
208311Res D
208312Res A
208312Res B
208313Res C
208313Res D
208314Res A
208314Res B
208315Res C
208315Res D
208316Res A
208316Res B
208317Res C
208317Res D
208318Res A
208318Res B
208319Res C
208319Res A
208320Res D
208320Res B
208321Res C
208321Res D
208322Res A
208322Res B
208323Res C
208323Res D
208324Res A
208324Res C
208325Res B
208325Res D
208326Res A
208326Res B
208327Res C
208327Res D
208328Res A
208328Res B
208329Res C
208329Res D
208330Res A
208330Res B
208331Res C
208331Res D
208332Res A
208332Res B
208333Res C
208333Res D
208334Res A
208334Res B
208335Res C
208335Res D
208336Res A
208336Res B
208337Res C
208337Res D
208338Res A
208338Res B
208339Res C
208339Res D
208340Res A
208340Res B
208341Res C
208341Res D
208342Res A
208342Res B
208343Res C
208343Res D
208344Res A
208344Res C
208345Res B
208345Res D
208346Res A
208346Res B
208347Res C
208347Res D
208348Res A
208348Res B
208349Res C
208349Res D
208350Res A
208350Res B
208351Res C
208351Res D
208352Res A
208352Res C
208353Res B
208353Res D
208354Res A
208354Res B
208355Res C
208355Res D
208356Res A
208356Res C
208357Res B
208357Res D
208358Res A
208358Res B
208359Res C
208359Res D
208360Res A
208360Res B
208361Res C
208361Res D
208362Res A
208362Res B
208363Res C
208363Res D
208364Res A
208364Res B
208365Res C
208365Res D
208366Res A
208366Res B
208367Res C
208367Res D
208368Res A
208368Res B
208369Res C
208369Res D
208370Res A
208370Res B
208371Res C
208371Res D
208372Res A
208372Res B
208373Res C
208373Res D
208374Res A
208374Res B
208375Res C
208375Res D
208376Res A
208376Res B
208377Res C
208377Res D
208378Res A
208378Res B
208379Res C
208379Res D
208380Res A
208380Res B
208381Res C
208381Res D
208382Res A
208382Res B
208383Res C
208383Res D
208384Res A
208384Res B
208385Res C
208385Res D
208386Res A
208386Res B
208387Res C
208387Res D
208388Res A
208388Res B
208389Res C
208389Res D
208390Res A
208390Res B
208391Res C
208391Res D
208392Res A
208392Res B
208393Res C
208393Res D
208394Res A
208394Res B
208395Res C
208395Res D
208396Res A
208396Res B
208397Res C
208397Res D
208398Res A
208398Res B
208399Res C
208399Res D
208400Res A
208400Res B
208401Res C
208401Res D
208402Res A
208402Res B
208403Res C
208403Res D
208404Res A
208404Res C
208406Res B
208406Res D
208407Res A
208407Res B
208410Res C
208410Res A
208411Res D
208411Res B
208412Res C
208412Res D
208414Res A
208414Res B
208415Res C
208415Res D
208417Res A
208417Res B
208418Res C
208418Res D
208419Res A
208419Res B
208420Res C
208420Res D
208421Res A
208421Res B
208422Res C
208422Res D
208423Res A
208423Res C
208424Res B
208424Res D
208425Res A
208425Res C
208426Res B
208426Res A
208427Res D
208427Res B
208428Res C
208428Res D
208429Res A
208429Res B
208430Res C
208430Res D
208431Res A
208431Res B
208432Res C
208432Res D
208433Res A
208433Res B
208434Res C
208434Res D
208435Res A
208435Res B
208436Res C
208436Res D
208437Res A
208437Res B
208438Res C
208438Res D
208439Res A
208439Res B
208440Res C
208440Res D
208441Res A
208441Res B
208442Res C
208442Res D
208443Res A
208443Res B
208444Res C
208444Res D
208445Res A
208445Res B
208446Res C
208446Res A
208447Res D
208447Res B
208448Res C
208448Res A
208449Res D
208449Res B
208450Res C
208450Res A
208451Res D
208451Res B
208452Res C
208452Res D
208453Res A
208453Res B
208454Res C
208454Res D
208455Res A
208455Res B
208456Res C
208456Res D
208457Res A
208457Res B
208458Res C
208458Res D
208459Res A
208459Res B
208460Res C
208460Res D
208461Res A
208461Res B
208462Res C
208462Res A
208463Res D
208463Res B
208464Res C
208464Res D
208465Res A
208465Res B
208466Res C
208466Res D
208467Res A
208467Res B
208468Res C
208468Res D
208469Res A
208469Res B
208470Res C
208470Res D
208471Res A
208471Res B
208472Res C
208472Res D
208473Res A
208473Res B
208474Res C
208474Res D
208475Res A
208475Res B
208476Res C
208476Res A
208477Res D
208477Res B
208478Res C
208478Res D
208480Res A
208480Res B
208481Res C
208481Res A
208482Res D
208482Res B
208483Res C
208483Res D
208484Res A
208484Res B
208485Res C
208485Res D
208486Res A
208486Res B
208487Res C
208487Res D
208488Res A
208488Res B
208489Res C
208489Res D
208490Res A
208490Res B
208491Res C
208491Res A
208492Res D
208492Res C
208493Res B
208493Res D
208494Res A
208494Res B
208495Res C
208495Res D
208496Res A
208496Res B
208497Res C
208497Res D
208498Res A
208498Res B
208499Res C
208499Res D
208500Res A
208500Res B
208501Res C
208501Res D
208502Res A
208502Res B
208503Res C
208503Res D
208504Res A
208504Res B
208505Res C
208505Res D
208506Res A
208506Res B
208507Res C
208507Res D
208508Res A
208508Res B
208509Res C
208509Res D
208510Res A
208510Res B
208511Res C
208511Res D
208512Res A
208512Res C
208513Res B
208513Res D
208514Res A
208514Res B
208515Res C
208515Res D
208517Res A
208517Res B
208522Res C
208522Res A
208523Res D
208523Res B
208524Res C
208524Res A
208525Res D
208525Res B
208528Res C
208528Res D
208529Res A
208529Res C
208530Res B
208530Res D
208533Res A
208533Res B
208534Res C
208534Res D
208535Res A
208535Res B
208536Res C
208536Res A
208538Res D
208538Res B
208539Res C
208539Res D
208540Res A
208540Res B
208541Res C
208541Res D
208542Res A
208542Res B
208544Res C
208544Res D
208545Res A
208545Res B
208546Res C
208546Res D
208547Res A
208547Res B
208548Res C
208548Res D
208549Res A
208549Res B
208550Res C
208550Res A
208551Res D
208551Res C
208552Res B
208552Res D
208554Res A
208554Res B
208555Res C
208555Res D
208556Res A
208556Res B
208557Res C
208557Res D
208559Res A
208559Res B
208560Res C
208560Res D
208561Res A
208561Res C
208562Res B
208562Res D
208563Res A
208563Res C
208565Res B
208565Res A
208566Res D
208566Res C
208568Res B
208568Res D
208569Res A
208569Res C
208571Res B
208571Res D
208572Res A
208572Res B
208573Res C
208573Res A
208574Res D
208574 
Labels:
Reply
0 Likes
10 REPLIES 10
Brankl
7 - Meteor
‎01-11-2024 10:05 AM

Hi Abhijeet. I'm attaching a workflow with the solution. As you can see in the screenshot, most of the overlap is A-B or C-D. You can use the overlap counts in each category to ensure the reallocation is evenly split across categories.

Alteryx Community - Res Groups.yxzp
12 KB
Reply
0 Likes
nagakavyasri
12 - Quasar
‎01-11-2024 11:05 AM

@AbhijeetChib Check if this meets your requirement:

 

Capture11.PNG

Multi row.yxmd
Reply
0 Likes
AbhijeetChib
8 - Asteroid
‎01-11-2024 01:19 PM

Hello ! 

 

thanks for your response 

Sum_AB Sum_AC Sum_AD Sum_BC Sum_BD Sum_CD
249 44 0 0 43 248

 

I need to ensure that the allocation is evenly distributed between all 4 of them. 

Reply
0 Likes
AbhijeetChib
8 - Asteroid
‎01-11-2024 01:20 PM

hello @Brankl 

thanks for your response 

Sum_AB Sum_AC Sum_AD Sum_BC Sum_BD Sum_CD
249 44 0 0 43 248

 

I need to ensure that the allocation is evenly distributed between all 4 of them. 

Reply
0 Likes
binuacs
20 - Arcturus
‎01-11-2024 02:06 PM

@AbhijeetChib Are you expecting any result from the given input data?

Reply
0 Likes
AbhijeetChib
8 - Asteroid
‎01-11-2024 02:10 PM

@binuacs Yes 

 

All the duplicate groups need to be equally allocated between Primary resources, but group should go to a pair of duplicate.group should go to one resource only

 

Duplicate group values are in pairs and are assigned to Primary. 

For example, duplicate group 207964 is assigned to Res A and Res B. 

207964Res A
207964Res B

 

I need to ensure that the pairs are assigned to only 1 resource. Expected output is below 

207964Res B
207964Res B

 

OR 

 

207964Res A
207964Res A

 

The catch is - Res A, Res B, Res C and Res D should be allocated equal number of records between them and their duplicate groups need to be the same. 

Reply
0 Likes
binuacs
20 - Arcturus
‎01-11-2024 02:13 PM

@AbhijeetChib Try the attached workflow, I dont see any matching primary and duplicate groups from your input, i created a sample file for the output

image.png

Duplicate_110124.yxmd
Reply
0 Likes
AbhijeetChib
8 - Asteroid
‎01-11-2024 02:45 PM

Thanks @binuacs 

I dont think I am making myself clear. Let me try again

 

Duplicate_GroupPrimary Assigned
207964Monty
207964Sam
207965Shawn
207965Kam
207966Monty
207966Sam
207967Shawn
207967Kam
207968Monty
207968Sam
207970Kam
207970Shawn
207971Monty
207971Sam
207972Shawn
207972Kam
207973Monty
207973Sam
207974Shawn
207974Kam
207975Monty
207975Sam
207976Shawn
207976Kam
207977Monty
207977Sam
207978Shawn
207978Kam
207979Monty
207979Sam
207980Shawn
207980Kam
207981Monty
207981Sam
207982Shawn
207982Kam
207983Monty
207983Sam
207984Shawn
207984Kam
207985Monty
207985Sam
207986Shawn
207986Kam
207987Monty
207987Sam
207988Shawn
207988Kam
207989Sam
207989Monty
207990Shawn
207990Kam
207991Monty
207991Sam
207992Shawn
207992Kam
207993Monty
207993Sam
207994Shawn
207994Kam
207995Monty
207995Sam
207996Shawn
207996Kam
207997Monty
207997Sam
207998Shawn
207998Kam
207999Sam
207999Monty
208000Shawn
208000Kam
208001Monty
208001Sam
208002Shawn
208002Kam
208003Sam
208003Monty
208004Shawn
208004Kam

 

In the above data set, the allocation for all 4 resources is equally distributed 

Primary AssignedCount
Sam20
Kam20
Shawn20
Monty20

 

However, if you see their Duplicate groups are different. For example in the below data set 207964 has Monty and Sam both. I need to either make it Sam or Monty. However the distribution counts across all 4 resources should be equal like the second table. 

207964Monty
207964Sam
Reply
0 Likes
AbhijeetChib
8 - Asteroid
‎01-11-2024 02:45 PM

@binuacs I hope I was able to make myself clear this time. 

Reply
0 Likes
learn more about the python upgrade coming in may 2024
Labels