- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
mapping data
Sr No | Zone | State | City | Branch Name | Branch ops Region | RM Name |
1 | West | Gujarat | Ahmedabad | Ahmedabad- **bleep**al Varsha | WEST 2 | Pragnesh Patel |
- | - | - | - | Ahmedabad-Ambavadi | - | - |
- | - | - | - | Ahmedabad-Ambavadi-2 | - | - |
- | - | - | - | Ahmedabad-C.G Road | - | - |
- | - | - | - | Ahmedabad-C.G Road-160 | - | - |
- | - | - | - | Ahmednagar-Nagar Shirdi Road-3 | - | - |
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Annapurna1 can you share the expected output
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
All ahmedabad branches should be mapped in one existing that is
Sr No | Zone | State | City | Branch Name | Branch ops Region | RM Name |
1 | West | Gujarat | Ahmedabad | Ahmedabad- **bleep**al Varsha | WEST 2 |
Regards,
Annapurna
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can somebody help me out please.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
u r expecting output like below?
Sr No Zone State City Branch Name Branch ops Region RM Name
1 West Gujarat Ahmedabad Ahmedabad- **bleep**al Varsha WEST 2 Pragnesh Patel
1 West Gujarat Ahmedabad Ahmedabad-Ambavadi WEST 2 Pragnesh Patel
1 West Gujarat Ahmedabad Ahmedabad-Ambavadi-2 WEST 2 Pragnesh Patel
1 West Gujarat Ahmedabad Ahmedabad-C.G Road WEST 2 Pragnesh Patel
1 West Gujarat Ahmedabad Ahmedabad-C.G Road-160 WEST 2 Pragnesh Patel
1 West Gujarat Ahmedabad Ahmednagar-Nagar Shirdi Road-3 WEST 2 Pragnesh Patel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Actually no
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is my Input,
Sr No | Zone | State | City | Branch Name | RM Name | TW Count | TW Value in CR | FM Count | FM Value in CR |
1 | West | Gujarat | Ahmedabad | Ahmedabad- **bleep**al Varsha | Sai Ram | 0 | 0 | 0 | 0 |
- | - | - | - | Ahmedabad-Ambavadi | - | 0 | 0 | 9827 | 25.85626996 |
- | - | - | - | Ahmedabad-Ambavadi-2 | - | 105694 | 229.7152379 | 0 | 0 |
- | - | - | - | Ahmedabad-C.G Road | - | 0 | 0 | 359 | 0.00010936 |
- | - | - | - | Ahmedabad-C.G Road-160 | - | 163981 | 1.469091526 | 0 | 0 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But my expected output should be as mentioned below,
Where Multiple branches should be mapped to only one existing branch and the count should also be added.
Please do the needful.
Sr No | Zone | State | City | Branch Name | RM Name | TW Count | TW Value in CR | FM Count | FM Value in CR |
1 | West | Gujarat | Ahmedabad | Ahmedabad- **bleep**al Varsha | Sai Ram | 269675 | 231.1843294 | 10186 | 25.85637932 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please Experts suggest me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure I got that completely right but maybe this helps:
You could use the wildmatch function to find records that start or end wil some specific text:
If ( Wildmatch ([Branch Name] , 'Ahmedabad*') , 'Ahmedabad' , 'Other city')
- « Previous Replies
-
- 1
- 2
- Next Replies »