Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

rajeshqvd
Contributor

Autonumber

Hi Please help on this I am trying to assign autonumber for days in a month

Ex:date,autoid

1/11/17,1

.

.

.

.

.

30/11/17,30

1/1217,1

.

.

.

.

31/12/17,31

Like this...... please help on this.

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: Autonumber

Why not Day(Date) as autoid.

Autonumber is slow.

However syntax is like this

LOAD Date,Autonumber(Day(Date),MonthName(Date)) as autoid

If You have dates like this

Date

02/10/2017

05/10/2017

then

Date,autoid

02/10/2017,1

05/10/2017,2

If You want 02 -> 2 and 05 -> 5 then use Day(Date).

4 Replies
karthikoffi27se
Contributor III

Re: Autonumber

Hi Rajesh

If it's just for 2 months please use a INLINE LOAD as assign a auto number value.

LOAD * INLINE

[

date,autoid

1/11/17,1

.

.

.

.

.

30/11/17,30

1/1217,1

.

.

.

.

31/12/17,31

];

This will create a auto number for dates.

Many Thanks

Karthik

rajeshqvd
Contributor

Re: Autonumber

Hi karthik,

Thanks for your reply that is not for 2months that is continues process.

antoniotiman
Honored Contributor III

Re: Autonumber

Why not Day(Date) as autoid.

Autonumber is slow.

However syntax is like this

LOAD Date,Autonumber(Day(Date),MonthName(Date)) as autoid

If You have dates like this

Date

02/10/2017

05/10/2017

then

Date,autoid

02/10/2017,1

05/10/2017,2

If You want 02 -> 2 and 05 -> 5 then use Day(Date).

rajeshqvd
Contributor

Re: Autonumber

Thank-you..... Autonumber is working for me

Community Browser