How to write sequence order as date.

[Naps_230]

Hi ,

I have source table T1.

  Date,       Amount
04/01/2016, 10
04/01/2016, 10
04/01/2016, 10
04/01/2016, 30
04/02/2016, 10
04/02/2016, 20

O/P-

  Date,         Amount,    Entryno
04/01/2016,   10 ,        1
04/01/2016,   10,         2
04/01/2016,   10,         3
04/01/2016,   30,         4
04/02/2016,   10,         1
04/02/2016,   20,          2

Its different two dates.

Help in script...

[Vegar]

I've not verified that this will work hence I am away of my computer, but give autonumber a try.

Assuming you have a rowId (primary key) in your table then this might work.

Load

Date,

Amount,

Autonumber(rowId, Date) as EntryNo

Resident T1;

Med vänlig hälsning, Vegar Lie Arntsen  

--

Sent from my Oneplus using K-9 Mail. Please excuse my brevity.

[Vegar]

I did a test and it should work.

Cheers

Vegar Lie Arntsen

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.