topic Re: QlikView Create dynamic field in QlikView

QlikView Create dynamic field

mattbrain — Fri, 20 Nov 2020 18:02:30 GMT

Morning

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

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:

Thanks everyone

marcus_sommer — Mon, 05 Oct 2015 11:00:52 GMT

Try something like this:

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

while iterno() <= Number;

- Marcus

tresB — Mon, 05 Oct 2015 11:24:47 GMT

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 — Mon, 05 Oct 2015 11:40:32 GMT

Try this,

Data:

LOAD * INLINE [

Code

B819RGSDESC

B819TGDESC

B819TGMDESC

];

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

DROP Table Data;

mattbrain — Mon, 05 Oct 2015 12:17:08 GMT

Fantastic everyone, thank you all for your help.

All working now, very much appreciated.