topic Re: Duplicate data for each record in QlikView

Duplicate data for each record

sujana1621 — Thu, 05 May 2016 14:59:42 GMT

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

Re: Duplicate data for each record

Nicole-Smith — Thu, 05 May 2016 15:11:50 GMT

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

Re: Duplicate data for each record

sunny_talwar — Thu, 05 May 2016 15:17:18 GMT

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;

Re: Duplicate data for each record

sujana1621 — Thu, 05 May 2016 15:33:34 GMT

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

Re: Duplicate data for each record

sunny_talwar — Thu, 05 May 2016 15:49:45 GMT

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.

Re: Duplicate data for each record

Thu, 05 May 2016 16:56:45 GMT

In Qlikview

The table box display distinct records only

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