Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | - | - |
@Annapurna1 can you share the expected output
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
Hi,
Can somebody help me out please.
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
Actually no
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 |
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 |
Please Experts suggest me
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')