Duplicate data for each record

[sujana1621]

Hi,

I have a data which shows as below:

ID	Name	Case
123	Mike
123		3
123
345	Robert
345		6
345
567	James	4
567
1234	Jim
1234		5
1234

Result i am looking for is:

ID	Name	Case
123	Mike	3
123	Mike	3
123	Mike	3
345	Robert	6
345	Robert	6
345	Robert	6
567	James	4
567	James	4
1234	Jim	5
1234	Jim	5
1234	Jim	5

I want data values to be repeated. Could someone please help me in how to do in the script and in the Table.

Thanks

[Nicole-Smith]

Please do not post your questions multiple times.  I have already answered your question on this thread: Duplicate the data for the same respondent

[sunny_talwar]

This may be:

Table:

LOAD * Inline [

ID, Name, Case

123, Mike,

123, ,3

123, ,

345, Robert,

345, ,6

345, ,

567, James, 4

567, ,

1234, Jim,

1234, ,5

1234, ,

];

FinalTable:

LOAD ID

Resident Table;

Left Join (FinalTable)

LOAD ID,

  MaxString(Name) as Name,

  Max(Case) as Case

Resident Table

Group By ID;

DROP Table Table;

[sujana1621]

Hi Sunny,

I got the above in the preview but I am looking in the Table Box. Below is how i get in table box. Please let me know if i have to change in the script to reflect in the table box.

ID	Case	Name
123	3	Mike
345	6	Robert
567	4	James
1234	5	Jim

Thanks

[sunny_talwar · Accepted solution]

This is because Table box only shows distinct combination of all the columns you display. Since the values are repeating you are not seeing them. But add them as dimension to straight table and use Count(ID) and you will see their multiple counts.

[#6]

In Qlikview

The table box display distinct records only

That's the reason it's not repeating duplicate values