load inline

[vignesh_s]

i loaded the following value,but when i list it ,im geting only one 9 insted of 2 9's

LOAD * INLINE [

    ID

    10

    9

    9

    8

    7

    6

];

[Chanty4u]

in list box you wil get only distinct values

[Chanty4u · Accepted solution]

load this and  create a table box in  front end

LOAD * INLINE [

    ID,pro

    10,a

    9,b

    9,c

    8,c

    7,d

    6,e

];

[vignesh_s]

even in pivot table or stright table im nt geting,i usend rank function as expression

[sunny_talwar]

Because one again, you only have one dimension (ID) and unless you add another one which essentially repeats the ID, it will only be shown once. You can add another expression as Count(ID) and you will see that ID 9 will have a count of 2

[Anil_Babu_Samineni]

May be work around

[Anil_Babu_Samineni]

Instead, Generate to call RecNo() as ID

[Chanty4u]

yes anil,

but just wanted to show him with other dimension

[vignesh_s]

i have 2 9's so im geting 2-3 and 2-3 for 8 i got 4 ,so i should get 3 as rank for 8,can i get the expression for tat

[sunny_talwar]

Try see if you can understand from this thread

Continuous Ranking (no missing Rank)