how to split excelsheet cell values in qlikview

[Anonymous]

Hai experts.

how to split excel sheet cell values in qlikview. For example my data is below model, i will get data as output & count the values in excel sheet.

Header 1	Header 2	Header 3
sap	output	count
1,2,3	1	3
4	2	1
5	3	1
6,7	4	2
	5

[marcus_sommer]

You could use something like this:

load sap, subfield(sap, ',') as output, rangesum(substringcount(sap, ','), 1) as count

from excel;

- Marcus