2 Replies Latest reply: Jan 6, 2017 5:43 AM by Vegar Lie Arntsen RSS

    How to write sequence order as date.

    Jasobanta Pradhan

      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...

       

       

        • Re: How to write sequence order as date.
          Vegar Lie Arntsen

          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.

          • Re: How to write sequence order as date.
            Vegar Lie Arntsen

            I did a test and it should work.

             

            image001.png

             

             

             

            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.