Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need to add a new table using load script.
I have a master table with patientIDs, and their visit summary (name, purpose, diagnoses, location,charge etc).
The PatientIDs repeat throughout the table whenever the patient revisits.
I need a new table which consolidates all the unique patientIDs in one column and the second column should have the count of each patientID (which would be the number of times he visited).
For example if the below table is the data set:
I want the result table which looks like below:
This should work:
[Visit_Count_Table]:NoconcatenateLOAD[ID],Count([Name]) as [Visit Count]RESIDENT [Visit_Table]
GROUP BY [ID];
View solution in original post
Patients:Load * Inline[ID,NameID001,abcID001,abcID001,abcID002,yhnID002,yhnID003,ujnID004,koiID004,koi];Load ID,Count(Name) as TotalVisitsResident PatientsGroup By ID;
Thank you, it worked without the concatenate.