Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Creator
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
Specialist III
Specialist III

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

Thanks @edwin .

logic is working perfectly.

 

View solution in original post

3 Replies
edwin
Specialist III
Specialist III

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

Thanks @edwin .

logic is working perfectly.

 

View solution in original post

edwin
Specialist III
Specialist III

yw