13 Replies Latest reply: Jan 15, 2014 1:54 PM by Vegar Lie Arntsen RSS

    How to tranform table/generate data

    Jörg Hildebrandt

      I have a table with entry nos. which refer to a "from entry" and "to entry" numbers.

       

      It looks like this:

      No.From entry No.To entry No.
      9911617780731778084
      9911717780851778088
      9911817780891778092

       

      I like to transform the data to get the result like follows (I had a look into "Generating missing data", but failed).

       

      No.From Entry No.To Entry No.
      9911617780731778084
      9911617780741778084
      9911617780751778084
      9911617780761778084
      9911617780771778084
      9911617780781778084
      9911617780791778084
      9911617780801778084
      9911617780811778084
      9911617780821778084
      9911617780831778084
      9911617780841778084
      9911717780851778088
      9911717780861778088
      9911717780871778088
      9911717780881778088
      9911817780891778092
      9911817780901778092
      9911817780911778092
      9911817780921778092

       

      Attached is a sample qvw, it would be great if someone could assist me.

       

      Joerg