Rename Initial Conditional with airSlate SignNow

Rename initial conditional

so we want to import data by the name bib's county name so what you need to do is go to your data new source the data remember is in form of a text so text stop csv and this is the data that we're talking to we are talking about it is called peeps county name so click on the fifth county name and then open click on the fifth county name and then you open we want to import this data it is informal.txt so are we you're going to have this interface remember the columns are not labeled we are going to understand the reason is why they are not labeled and how we can be able to label the columns or rename the columns we just have column one and column two so click ok and then eventually we have the fifth county name is a query on our power query editor so this is the data that we have um number one we want to change column one from being of the data type number to being of the data type text to do this we said you click on this feature on the left side of the column header and then it is now in form of a number you choose text you're going to get all these prompts asking you if you want to change so replace current and you can see the alignment of the values of column 1 is changing initially it was right aligned because it was a number when it changes to a text it is aligned to the left right so after con converting our column one to text uh we want to split column two and to split column two we shall be splitting this column using the delimiter of a comma so to do that click on column two then right click there will be a lot of um transformations that you can do but i want us to look at split this split column here by delimiter split column by delimiter okay and we are splitting this is the comma we don't really need a quote character so you can click ok once you click ok you're going to realize that column two is going to be split into two um we have instances where we never had uh a comma so you can see it is now null where you add a comma you can see it has been split into two columns now if you look at these um you may be familiar with some of these names and these are county names the united states and you can see united states is also appearing here so we need to filter out united states we need to filter out united states so let's filter out united states click on the filter button and then now you have to um you can use the text filters here so filter does not equal to you...