Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Please do not post your questions multiple times. I have already answered your question on this thread: Duplicate the data for the same respondent
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;
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
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.
The table box display distinct records only
That's the reason it's not repeating duplicate values