count of field values

[#1]

hi all,

I have a table with two columns user_id and percentage_score in results table. I have attached the sample csv file.

while loading the data i need to load user_id and count of each user_id.

for example: user_id = 476 i have two times in table so i need count as 2.

After loading table should look like below:

User_id	count
124	1
22	1
32	1
45	1
57	2
476	2
2	3
77	1
14	1
23	3
17	1
432	2

Please note this i need this data while loading only.

Thanks,

Pramod

[#2]

would you please send me that .qvf file.

[pokassov]

I'm sorry. I have tried script for QV11.

However, I tried it for QlikSense too.

Here the code, which I checked:

LOAD distinct

    user_id

FROM [lib://Downloads/correct.csv.xlsx]

(ooxml, embedded labels, table is Sheet1);