If you want to apply a small tweak to the document, it should not require much time to Choose columns record. This kind of simple action does not have to require extra education or running through handbooks to learn it. Using the right document modifying resource, you will not spend more time than is needed for such a quick change. Use DocHub to simplify your modifying process regardless if you are a skilled user or if it’s the first time making use of a web-based editor service. This instrument will take minutes or so to learn to Choose columns record. The only thing needed to get more productive with editing is a DocHub account.
A plain document editor like DocHub can help you optimize the amount of time you need to devote to document modifying no matter your previous knowledge about this kind of instruments. Make an account now and boost your efficiency instantly with DocHub!
[Music] hello and welcome to exceed learning in this video were going to talk about a cool function called record.field which can help us to filter table based on the column position rather than column name we had a client which had some specific issue with filtering of the tables so every time he received a table the table has had different structure names different names of the of the columns and he had to find a way to filter always the second column from table he was unable to use all other features like demoting headers he always had to keep the structure of the table so do not mess with the structure just always take the second column and filter it to a specific value so we looked upon a solution and we found one with this function so we will go through the solution together first lets put this table into power query so lets load it from table range and this is a pretty simple table we would want to filter by the second column so this column currently is named product and the