Allocate line items to various users

[BobjiK]

Hello Everyone

I am new to Alteryx development. Kindly help me. 

I have a requirement. I will be given a spreadsheet where every 2 rows constitutes one invoice. I will be given one more spreadsheet with the names of various team members.

The requirement is that every 2 rows from the first spreadsheet will have to be allocated to the people mentioned in the 2nd spreadsheet. It must be done in such a way that these rows must be allocated equally among the team members in the 2nd sheet.

Kindly help.

Thanks

Bobji

[caltang]

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

[BobjiK]

Hi Caltang

Thanks for your response. Once I receive the files, I will be in a position to send the screenshot. I have not yet designed any workflow. 

[caltang]

You are asking in advance? 

May I ask... where is that data from? 

[BobjiK]

The data will be on a couple of spreadsheets. 

[caltang]

Okay great... do you have sample data and an expected output then?