Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. 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