Ahmed Fawad
Board Regular
- Joined
- Mar 1, 2011
- Messages
- 63
- Office Version
- 2016
- Platform
- Windows
Hi here is the table
<tbody>
</tbody>
thats the data and here I'm doing input to get the details:
<tbody>
</tbody>
Now from data from data LOCATION CODE is combination of cluster and property.
i.e. cluster 5 property 12 is the 512 location code.
Now i need the name of the customer from locationcode 512.
Any help ?
LocationCode | CustomerName | Party_Type | City |
501 | Tamweel (P.J.S.C) | ORGANIZATION | Dubai |
502 | Tamweel (P.J.S.C) | ORGANIZATION | Dubai |
503 | Tamweel (P.J.S.C) | ORGANIZATION | Dubai |
504 | IL KANG | PERSON | dubai |
505 | Ahmed Farukh Sameen Alam | PERSON | Dubai |
506 | Akshaya Kumar Parija | PERSON | Dubai |
507 | Saleem Mirza | PERSON | UAQ |
508 | Tamweel (P.J.S.C) | ORGANIZATION | Dubai |
509 | Manab Kumar Kundu | PERSON | Dubai |
510 | ASHOK RUPANI KOMAL | PERSON | DUBAI |
511 | Mark Kremers | PERSON | |
512 | Lana B. S. Nahawi | PERSON | Dubai |
513 | Moussa Abdourahman Ahmed | PERSON | DUBAI |
514 | Victor Ramanan | PERSON | DUBAI |
515 | RACHID AL ASSAF | PERSON | dubai |
516 | Zareen Akhtar Butt | PERSON | Bur Dubai: Dubai |
<tbody>
</tbody>
thats the data and here I'm doing input to get the details:
Cluster | Property | Name | Type | City | REMARKS |
5 | 12 | ||||
5 | 9 | ||||
5 | 4 | ||||
<tbody>
</tbody>
Now from data from data LOCATION CODE is combination of cluster and property.
i.e. cluster 5 property 12 is the 512 location code.
Now i need the name of the customer from locationcode 512.
Any help ?