 Hello, in this video we are going to aggregate the Korean level 3 classes to level 1. In the attribute table you can see that the classes are in the code 18 field and it consists of 3 digits. The last digit is the level 3 class, the second the level 2 class and the first digit the level 1 class. So let's create a new field that we call level 1. It is a whole number integer so we keep the default. Then under fields and values you can see code 18 and the ABCB4 indicates that it is a string. So we can use string functions. And there's a function called left which returns the end character of the string from the left. So if I use it, left and then a bracket, code 18, comma 1, it will take the first character. In the preview we see there a number 1. But now we want to convert this to integer. So we use the to end function and wrap the rest in that function. That also gives a correct preview. If I click OK, this is applied in a new field with level 1, code is created and we can check that there in this case number 3 is retained. Let's save the attribute table. For our further calculations we need to dissolve these classes so we go to dissolve and as a dissolve field we choose the level 1 classes and in such a way these classes will become one feature. Let's save it in our geo package and I call it coring 2018 dissolved. So here we can see that there are 5 level 1 class features. Let's style the result. The level 1 doesn't come with a legend file so we need to base it on the level 3 classes by having similar colors. So go to categorized and choose the level 1 field and click classify. Remove the all other classes field which captures the null values but they are not there and add the class names to the legend and also change the colors to more intuitive colors based on the original level 3 classification. So in this video you have learned how to aggregate the coring level 3 classes to level 1 and to dissolve the classes so each class is one feature and to style it using colors that are based on the original coring level 3 classes.