Number Sequence

[Anonymous]

Hello,

I have Program No and Date ,I want sequence to be created.

Sequence should be created for each Program No and Ascending order of date

Program No        Date        Sequence
30                 04-Apr-2011        1
40                 04-Apr-2011        1
70                04-Apr-2011        1
80                01-Apr-2011        1
80                02-Apr-2011        2
80                03-Apr-2011        3
80                04-Apr-2011        4
100               04-Apr-2011        1
110               05-Apr-2011        1
160              05-Apr-2011        1
170              04-Apr-2011        1
170               05-Apr-2011        2
170              06-Apr-2011        3
180              07-Apr-2011        1
190              06-Apr-2011        1
200              07-Apr-2011        1

201               30-Apr-2011       1

201               1-May-2011       2

Thanks

[sunny_talwar]

Efficient solutions as well as alternative solutions for doing the same thing. I think he is one person I love seeing the response from just because they are so detailed. I have lately tried to copy his technique of providing as much details as possible in my responses.

[MarcoWedel]

thank you.

Most of what I learned, I learned in the Community, meaning from you also.

Qlik on

Marco

[#4]

Hello Harinder,

Hope this will help you out.

Main:

Load * Inline [

ProgramNo,Dates

30, 04-Apr-2011       

40, 04-Apr-2011        

70, 04-Apr-2011        

80, 01-Apr-2011        

80, 02-Apr-2011        

80, 03-Apr-2011        

80, 04-Apr-2011        

100, 04-Apr-2011       

110, 05-Apr-2011        

160, 05-Apr-2011        

170, 04-Apr-2011       

170, 05-Apr-2011        

170, 06-Apr-2011        

180, 07-Apr-2011       

190, 06-Apr-2011        

200, 07-Apr-2011       

201, 30-Apr-2011      

201, 1-May-2011      

];

Tab2:

Load *,AutoNumber(ProgramNo&Dates,ProgramNo) as Sequence Resident Main

Order by ProgramNo,Dates;

Drop Table Main;