Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Partner - Creator
Partner - Creator

Change one field name into another field value.

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

START ENDSUBDIVISIONDAYSDELAY
1234567REGULAR10010
     

 

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--

START ENDSUBDIVISIONDAYS
1234567REGULAR100
1234567DELAY10

 

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

Labels (1)
2 Solutions

Accepted Solutions
edwin
Master
Master

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;

View solution in original post

Architect
Partner - Creator
Partner - Creator
Author

Thanks @edwin .

logic is working perfectly.

 

View solution in original post

3 Replies
edwin
Master
Master

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
Partner - Creator
Partner - Creator
Author

Thanks @edwin .

logic is working perfectly.

 

edwin
Master
Master

yw