You know you are using the right document editor when such a simple task as Use columns record does not take more time than it should. Editing documents is now an integral part of many working operations in numerous professional fields, which is why convenience and efficiency are essential for editing instruments. If you find yourself researching guides or trying to find tips about how to Use columns record, you might want to find a more user-friendly solution to save your time on theoretical learning. And here is where DocHub shines. No training is needed. Just open the editor, which will guide you through its main functions and features.
A workflow gets smoother with DocHub. Take advantage of this instrument to complete the paperwork you need in short time and get your efficiency to the next level!
[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