Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Annapurna1
Contributor III
Contributor III

mapping data

Hi,
 
I have multiple branches in one city or multiple branch names in our system, so need to map data of all branches into existing branches in a particular city. 
 
Example as per below - Five different branch name showing in our system for Ahmedabad branch, So need to map data of all Ahmedabad branches  in to Existing branch name - Ahmedabad **bleep**al Varsha
 
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 - -
             
             
13 Replies
Taoufiq_Zarra

@Annapurna1  can you share the expected output

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Annapurna1
Contributor III
Contributor III
Author

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 

Annapurna1
Contributor III
Contributor III
Author

Hi,

Can somebody help me out please.

anat
Master
Master

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

Annapurna1
Contributor III
Contributor III
Author

Actually no

 

Annapurna1
Contributor III
Contributor III
Author

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
Annapurna1
Contributor III
Contributor III
Author

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
Annapurna1
Contributor III
Contributor III
Author

Please Experts suggest me

Gui_Approbato
Creator III
Creator III

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')