Need help Counter Funtion

[NavinReddy]

Hi All,

Could some help me this Query

p	p1,p2,p3,p1,p1
q	q1,q2,q3,q2,q2
r	r1,r2,r3,r1,r1
s	10101

By using counter function How should i display like it

p	p1
q	q1
r	r1

if im wrong corrent me how should i disply like the way

Thanks & Regards

Niranjan

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

edit:

// The script to load some example data

Input:

LOAD *, if(not isnum(F2), SubField(F2,',')) as F3 INLINE [

    F1, F2 

    p    , "p1,p2,p3,p1,p1"

    q    , "q1,q2,q3,q2,q2"

    r    , "r1,r2,r3,r1,r1"

    s   , 10101

];

Add a straight table with F1 as dimension and as expression FirstSortedValue(F3, -aggr(count(F3),F3))

[NavinReddy]

Hi Gysbert,

im using persional edition so i can't able to open will you plz copy and paste it here

Thanks & Regards

Niranjan

[Sokkorn]

Hi Niranjan,

Try this

1. Load data

[Data]:

LOAD * INLINE [

    Field1, Field2 

    p    , "p1,p2,p3,p1,p1"

    q    , "q1,q2,q3,q2,q2"

    r    , "r1,r2,r3,r1,r1"

    s   , 10101];

2. Create Straight table

    a. Dimension: Field1

    b. Expression: If(IsNum(Field2),Null(),SubField(Field2,',',1))

Regards,

Sokkorn