Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to map rows of BranchName with my existing row BranchName1.
This is Qlik Output.
Sr No | Zone | State | City | BranchName | BranchName1 | Branch ops Region | RM Name | Branch Ops | Manpower Count | Single Manpower | TW Count | TW Value in CR |
3 | West | Gujarat | Ahmedabad | Ahmedabad- **bleep**al Varsha | Ahmedabad- Navrangpura | WEST 2 | Pragnesh Patel | Yes | 6 | Multiple | 0 | 0 |
- | West | Gujarat | Ahmedabad | Ahmedabad-Ambavadi | Ahmedabad- Navrangpura | WEST 2 | Pragnesh Patel | - | 6 | Multiple | 0 | 0 |
- | West | Gujarat | Ahmedabad | Ahmedabad-Ambavadi-2 | Ahmedabad- Navrangpura | WEST 2 | Pragnesh Patel | - | 6 | Multiple | 105694 | 229.7152379 |
- | West | Gujarat | Ahmedabad | Ahmedabad-C.G Road | Ahmedabad- Navrangpura | WEST 2 | Pragnesh Patel | - | 6 | Multiple | 0 | 0 |
- | West | Gujarat | Ahmedabad | Ahmedabad-C.G Road-160 | Ahmedabad- Navrangpura | WEST 2 | Pragnesh Patel | - | 6 | Multiple | 163981 | 1.469091526 |
But my expected output is, Both the branch names should be mapped and the count of TW and TW value should also be add with each other
Sr No | Zone | State | City | BranchName1 | Branch ops Region | RM Name | Branch Ops | Manpower Count | Single Manpower | TW Count | TW Value in CR |
3 | West | Gujarat | Ahmedabad | Ahmedabad- Navrangpura | WEST 2 | Pragnesh Patel | Yes | 6 | Multiple | 2,69,675 | 231.17 |
Help me out