topic Re: How to assign row number with time based in QlikView

How to assign row number with time based

Srinivas — Wed, 07 Oct 2015 09:18:01 GMT

Hi All,

I want to assign row count with time based we need to assign row count like my out put way , Here my maximum time is 8/2/2015 so that is max count.

ID	Action	Creation_Date
123 - NA	Positive	8/1/2015
123 - NA	Negative	8/2/2015

I am expecting Out put like below way :

ID	Action	Creation_Date	Row
123 - NA	Positive	8/1/2015	1
123 - NA	Negative	8/2/2015	2

Regards,

Srinivas

Re: How to assign row number with time based

MK_QSL — Wed, 07 Oct 2015 09:22:24 GMT

T1:

Load ID, Action, Creation_Date From TableName;

NoConcatenate

T2:
Load

AutoNumber(ID&Creation_Date,ID) as Row

Resident T1

Order By ID, Creation_Date;

Drop Table T1;

Re: How to assign row number with time based

Kushal_Chawda — Wed, 07 Oct 2015 09:25:56 GMT

load * ,

AutoNumber(Creation_Date,ID) as Row

From Table

Re: How to assign row number with time based

sujeetsingh — Wed, 07 Oct 2015 09:35:27 GMT

Use ROW no function with order by.

Re: How to assign row number with time based

martyn_birzys — Wed, 07 Oct 2015 17:20:04 GMT

RecNo() as Rec

RowNo() as Row

Re: How to assign row number with time based

maniram23 — Wed, 07 Oct 2015 18:17:28 GMT

Hi Srinivas

you can try "Rowno()" function.

Re: How to assign row number with time based

jonas_rezende — Wed, 07 Oct 2015 18:34:39 GMT

Hi, M srinivas.

Try.

tempTable1:

LOAD

ID,

Action,

Creation_Date

From TableName;

NoConcatenate

Table1:

LOAD

ID,

Action,

Creation_Date,

RowNo() as Row

Resident tempTable1

order by Creation_Date // By default is asc.

Drop table tempTable1;

Hope this helps!

Re: How to assign row number with time based

MarcoWedel — Wed, 07 Oct 2015 21:32:42 GMT

Hi,

one solution could be also:

hope this helps

regards

Marco