Store file using a ticket basis

[rammuthiah]

For eg. I have 10 tickets assigned to 5 members 2 tickets per member. I need to read those names, ticket no using for loop

and store as separate file for each member by stating the message as "You have TCT1, TCT2" in your bucket.

Ticket	Name
1	Diya
2	Saina
3	Neha
4	Evangeline
5	Rena
6	Rena
7	Evangeline
8	Neha
9	Saina
10	Diya

I want to store like Diya.xlsx, Reena.xlsx and so on which contains  

Diya which contains Ticket assigned 1,10

Saina which contains Ticket assigned 2,9

which contains Ticket assigned 3,8

which contains Ticket assigned 4,7

which contains Ticket assigned 5,6

[Vegar · Accepted solution]

Try something like this.

Data:

Load Ticket, Name

From Source;

For each _name in fieldvaluelist('Name')

[$(_name)]:

Load
'$(_name) which contains Ticket assigned ' & Concat(Ticket, ',') as Message

Resident Data

Where Name = '$(_name)';

Store [$(_name)] Into [$(_name).qvd] (qvd);

Drop table  [$(_name)];

Next

[rammuthiah]

Even for every single Assignee it shows overall count, not the individual count. Is this possible to rectify it?