vishal0589
Board Regular
- Joined
- May 13, 2014
- Messages
- 63
Hi Friends,
I am working on large dataset having daily entry around 3K rows and around 70K (Monthly) . I have setup a Bi-weekly format to analyse the same with 3 criteria.
I have used the Array function to retrieve maximum 3 matching text values for selected criteria.
Suppose
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Criteria:
<colgroup><col><col><col><col span="9"></colgroup><tbody>
</tbody>
I am working on large dataset having daily entry around 3K rows and around 70K (Monthly) . I have setup a Bi-weekly format to analyse the same with 3 criteria.
I have used the Array function to retrieve maximum 3 matching text values for selected criteria.
Suppose
Date | Post Code | Shift | Service No | Name | Designation | Post Name | Location | Shift Hours | Flag | Duty |
01/08/2014 | 5 | 2:00 PM To 10:00 PM | 124 | Alba Softech Pvt Ltd. Gurgaon | Gurgaon | 8 | 1 | G8 | ||
01/08/2014 | 2 | 6:00 AM To 2:00 PM | 2421 | UPDESH KUMAR | G/M | Ahuja & Sons A-50 Naraina Delhi | Delhi | 8 | 1 | M8 |
01/08/2014 | 5 | 8:00 AM To 8:00 PM | 2463 | KRISHNA KUMAR CHAUDHARY | S/G | Alba Softech Pvt Ltd. Gurgaon | Gurgaon | 12 | 1 | G12 |
01/08/2014 | 3 | 7:00 AM To 7:00 PM | 2511 | NEM SINGH | G/M | Airworth Tours And Travel Pvt Ltd, Nehru Place Del | Delhi | 12 | 1 | M12 |
01/08/2014 | 3 | 2:00 PM To 10:00 PM | 2511 | NEM SINGH | G/M | Airworth Tours And Travel Pvt Ltd, Nehru Place Del | Delhi | 8 | 2 | MD8 |
01/08/2014 | 5 | 7:00 AM To 11:00 PM | 2585 | RAJENDRA KUMAR | S/G | Alba Softech Pvt Ltd. Gurgaon | Gurgaon | 16 | 1 | G16 |
01/08/2014 | 4 | 9:00 AM To 9:00 PM | 2620 | SANJAY KUMAR | G/M | Alba Softech (Home) D 3/11 Dlf I Gurgaon | Gurgaon | 12 | 1 | M12 |
01/08/2014 | 4 | 10:00 PM To 6:00 AM | 2620 | SANJAY KUMAR | G/M | Alba Softech (Home) D 3/11 Dlf I Gurgaon | Gurgaon | 8 | 2 | MD8 |
01/08/2014 | 5 | 8:00 AM To 8:00 PM | 2673 | SURENDER KUMAR | S/G | Alba Softech Pvt Ltd. Gurgaon | Gurgaon | 12 | 1 | G12 |
01/08/2014 | 2 | 9:00 AM To 9:00 PM | 2740 | TILAKDHARI | S/G | Ahuja & Sons A-50 Naraina Delhi | Delhi | 12 | 1 | G12 |
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Criteria:
Period Start Date : | Friday, 01 August, 2014 | Enter Post Code: | 2 |
<colgroup><col><col><col><col span="9"></colgroup><tbody>
</tbody>
Service No. | Fri | Sat | Sun | |||||||
1-Aug-14 | 2-Aug-14 | 3-Aug-14 |