06-27-2016 01:18 AM
I have the Employee List and front of them have the city where they belong, I want to give the Customers to these employees based on category which i have created.
Table 1. So i have the Employee , city , and the count of customers needed from the category ( Two category 1 & 2)
Table 2. I have Customers and City and Category in next table.
I want to extract the Customers and want to give to the employee
I have mention the category wise count which is needed
Output needed :-
CUSTOMER NAME , CITY , CATEGORY , EMPLOYEE NAME
Attacing the Excel file for the same