2 Replies Latest reply: Mar 13, 2017 2:14 PM by Sunny Talwar RSS

    Generate a sequence in rows

    Jose Maria Sanchez Herrero

      Hello everyone,

       

      I'm facing a trouble trying to generate new rows for a content between two values. I have the following simple example:

      VALUE1VALUE2NUMBEROFVALUESPREFIX
      ES001ES0044ES
      CS002CS0032CS

       

      And I would like to obtain the following result

      VALUE1VALUE2NUMBEROFVALUESRESULT
      ES001ES0044ES001
      ES001ES0044ES002
      ES001ES0044ES003
      ES001ES0044ES004
      CS002CS0032CS002
      CS002CS0032CS003

       

      Does anybody know how can I get this?

       

      Thank you very much

       

      Kind regards