QlikView Create dynamic field

[mattbrain]

Morning

Can anyone offer off any assistance with this issue please. I have a spreadsheet that looks a bit like this:

Code	Number
B819RGSDESC	4
B819TGDESC	3
B819TGMDESC	3

I am trying to find a way to dynamically create the Code field, to copy the Code field, with the number in the Number column.

Hope that makes sense, would basically create two tables that looks like this:

NewHeader	Code
B819RGSDESC1	B819RGSDESC
B819RGSDESC2	B819RGSDESC
B819RGSDESC3	B819RGSDESC
B819RGSDESC4	B819RGSDESC
B819TGDESC1	B819TGDESC
B819TGDESC2	B819TGDESC
B819TGDESC3	B819TGDESC
B819TGMDESC1	B819TGMDESC
B819TGMDESC2	B819TGMDESC
B819TGMDESC3	B819TGMDESC

Thanks everyone

[marcus_sommer]

Try something like this:

Load Code as NewHeader, iterno() as IterNo, rowno() as RowNo, recno() as RecNo From YourExcel

while iterno() <= Number;

- Marcus

[tresesco]

Try like:

Load
      Code,
     Code&IterNo() as NewHeader

While IterNo()<=Number;

LOAD Code,
    Number
FROM
[https://community.qlik.com/thread/185412]
(html, codepage is 1252, embedded labels, table is @1) where not isnull(Code);

[sunilkumarqv]

Try this,

Data:

LOAD * INLINE [

   Code

   B819RGSDESC

   B819RGSDESC

   B819RGSDESC

   B819RGSDESC

    B819TGDESC

    B819TGDESC

    B819TGDESC

    B819TGMDESC

    B819TGMDESC

    B819TGMDESC

];

LOAD Code&AutoNumber(RecNo(),Code) as NewHead,Code Resident Data;

DROP Table Data;

[mattbrain]

Fantastic everyone, thank you all for your help.

All working now, very much appreciated.