Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Allocate data to given members

Lalaiah
8 - Asteroid

Hi Team,

 

I have raw data which is pulled from the data source and contain case number so I need to allocate available members for the day. In another sheet, I have updated the names to those whom need to allocate one by one.

 

attached 2 files for your reference.

 

Regards,

Lalaiah

5 REPLIES 5
Emil_Kos
17 - Castor
17 - Castor

Hi @Lalaiah,

 

I don't get it. How many cases one person can pick up?

 

In one file you have 12 categories and in a second file only 5. 

Lalaiah
8 - Asteroid

"Raw data" file in B column there are case numbers, in C column we need to allocate the persons who are available in "Available resource" file (This person will change depends on the availability particular day)

 

 

Qiu
20 - Arcturus
20 - Arcturus

@Lalaiah 
Hope I get you right.

0316-Lalaiah.PNG

Lalaiah
8 - Asteroid

Thank you so much for your reply!!

 

However, the allocated persons will change on daily basis. I mean number of people will change as you mentioned 5 in the formula but it will change on daily so I need to automize without manual intervention in the process flow.

 

Regards,

Lalaiah

Emil_Kos
17 - Castor
17 - Castor

Hi @Lalaiah,

 

Thank you for clarifying

 

Emil_Kos_0-1615883980250.png

I have created a workflow for you it is fully dynamic. 

 

At least I think so 😄

Labels