Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

CLUBING THE DATA

hi below is my example data.

                                      

ITCSEROBOECE
IT-1YEARCSE-1YEARROBO-1YEARECE-1YEAR
IT-2YEARCSE-2YEARROBO-2YEARECE-2YEAR
IT-3YEARCSE-3YEARROBO-3YEARECE-3YEAR
IT-4YEARCSE-4YEARROBO-4YEARECE-4YEAR

how to club these IT years( 1yr, 2yr, 3yr and 4yr) under one field of IT Dept, like the same thing has to be done for other depts.

can you help me, how  to club all these(years) in one dept in load script.

1 Reply
buzzy996
Master II
Master II

try this,

IT&'-'&IT-1YEAR&'-'&IT-2YEAR&'-'&IT-3YEAR&'-'&IT-4YEAR as ITDept