Data Prep Help

[pawanmalik]

Hi,

I have following data in two files.

First file contains list of traders which are currently not assigned to an area.

Trader	Reg No	Area
A	1
B	2
C	3
D	4
E	5
F	6
G	7
H	8
I	9
J	10

Second file contains slots available for each area.

Area	Availability
Sydney	2
Melbourne	3
Brisbane	1
Adelaide	0
Perth	1
Darwin	3

I want to check the availability for each area and assign the area to traders in order of their registration numbers. This process needs to be automated for n number of traders. 

Can someone point me in the right direction on how to go about this task.

Thanks.

[atcodedog05 · Accepted solution]

Hi @pawanmalik ,

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @pawanmalik 

Cheers and Happy Analyzing 😀

[pawanmalik]

Thanks @atcodedog05  😁