Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi below is my example data.
IT | CSE | ROBO | ECE |
IT-1YEAR | CSE-1YEAR | ROBO-1YEAR | ECE-1YEAR |
IT-2YEAR | CSE-2YEAR | ROBO-2YEAR | ECE-2YEAR |
IT-3YEAR | CSE-3YEAR | ROBO-3YEAR | ECE-3YEAR |
IT-4YEAR | CSE-4YEAR | ROBO-4YEAR | ECE-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.
try this,
IT&'-'&IT-1YEAR&'-'&IT-2YEAR&'-'&IT-3YEAR&'-'&IT-4YEAR as ITDept