5/3/2023 0 Comments Power rename![]() Okay, education, senior level, employee status and remote worker. Collector ID, start date, age, education, senior level, employee status and remote worker. So let me go ahead and do file closing return. And now what I want to do is actually compare it to my original scenario. All right, I'll go ahead and close my window there. Perfect, I think I've accomplished all my steps. We named that employee status then our last but not least is do you consider yourself a remote worker and then this remote worker. Rename that to senior level, classify employment status. What is your highest level of education? Obviously is going to be called education, seniority level. All right, so what is your age? Obviously, it's going to be called age. And again, I have to size 'cause I want to be able to see. Give myself plenty of room here, all right. So far scroll down where I can see my headings, okay. ![]() So I'll just go here and uncheck that null. So I'll hold my shift key, I'll then right click and remove those columns, okay? My next step is to remove that extra row so that means this field right here. So my very first steps are to delete columns D through G. I'll restore my power query window because I do want to be able to see my code. So I'll go to data, get data from file, I'll choose workbook. In our objective it said to bring open a new workbook and clean it in. So I'm going to size this up because I really want to be able to see both. Okay, so I'm going to go ahead and size my window and then choose my book here, all right. I'll go to my visual basic and I've got my different pieces of code. And I've also got a new workbook open so I'm going to just switch between my windows there. ![]() So I have my study data open, let me navigate to that. (upbeat music) - You may or may not have enjoyed that challenge just depending on how much you like or don't like code, let me show you how I would tackle it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |