Map Rows

[Annapurna1]

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

[JordyWegman · Accepted solution]

Hi Annapurna,
I would say you just need to aggregate the data. Take all your fields except BranchName.

Load 
    [Your Fields],

     Sum( [TW]) as TW

FROM YourSource (QVD)

Group by [Your Fields]

;

I'm on a mobile phone, so it I can't type it that well.

Jordy 

Climber 

[Annapurna1]

Hi JordyWegman,

It is working,

Thank You