topic Change one field name into another field value. in QlikView

Change one field name into another field value.

Architect — Thu, 06 May 2021 15:53:49 GMT

Hi, Below you can see there is one table, having 5 columns.

here 5th column is 'DELAY' and the value is '10'.

what we have to do is make 'DELAY' a field value under 'SUBDIVISION', and '10' will become its corresponding

value under column 'DAYS'. the new table is like below--

can you help with the solution, how to achieve this?

edwin — Thu, 06 May 2021 17:35:34 GMT

if there are no complications, this should do:

concatenate (table) load START, END, 'DELAY' as SUBDIVISION, DELAY as DAYS resident table; drop field DELAY from table;

Architect — Sat, 08 May 2021 06:18:43 GMT

Thanks @edwin .

logic is working perfectly.

edwin — Mon, 10 May 2021 00:36:37 GMT