Uipath Get Row Item Example

This course offers a hands-on guide to automating a variety of software-controllable process using this popular tool. 37) In the UiPath Robotic Enterprise Framework template, in the Get Transaction Item state of the Main workflow, what happens before the next transaction item is retrieved? We check if the previous transaction has been completed; We check if a kill signal was sent from Orchestrator; We check if a stop signal was sent from Orchestrator. It can be useful at times to know what these indexes are, as they can be used for efficient selectors in the row(), column() and other API methods which use selectors. If you are using this blog post to pass your exam please re-consider using the following answers. Highlighting a row is easy using CSS, but for column highlighting, you need to use a little bit of Javascript. For example we may wan to delete duplicate rows in data or we may want to delete rows based on certain condition. The items are formatted in the list as "Code - Description". Using Column Name along with DataRow Object Drag “Get Row Item” activity and supply the desired fields to it. Youtube link UiPath link. In other words:. 0, there are two different ways to construct a ForEach-Object command. If you want to find out if an element is enabled or not, please use this activity or the Wait Attribute one, coupled with the aastate attribute, for example. What activity should you use if you want to add data to an existing. Robotic Enterprise Framework configured and optimized to get the input data from a tabular data source, such as an Excel or CSV file. Reads all the information from the specified sheet 83. Using a subselect command is the only way to get multiple levels of grouping, aggregation, or sorting in a single query. Using UiPath activity 2. In the first video in UiPath academy get row item event is used. It takes a collection as an input and iterates through each row of it (number of rows corresponds to the number of times loop gets executed). This is the UiPath introductory training. This can be useful for getting data from a row, or performing other row based operations, when you have only the DOM node for reference, for example in an event handler. @William You can use NewRow method of the datatable to get a blank datarow and with the schema as that of the datatable. Step 10: Execute this sequence by clicking on the Run button. Click Insert > Module, and paste the following code in the Module window. Please upgrade your browser. Drag four Assign activities right after the Get Row Item activities. Since both Dictionary and Hashtable are internally hashtables, so fast access to many-item data according to key, also both need immutable and unique keys. But is there any method can achieve it without remembering formulas?. I can't recall working on any actual-world RPA bot where I haven't used the loop stage. so I have to get the value from the row with other method, all the tables has the same columnName and the tablesname are deferent, the the within the tables are simple strings, so I need to get a ramdon row for each table, I hope this helps, I have tried everything and anything works!!. COALESCE function can be used to get comma separated (delimited) values from Table in the following SQL Server versions i. This is how it's done with UiPath:. Column A note on columns: In VBA, you usually end up working with column numbers. For example, when creating an absolute R1C1-style reference to the first cell in a worksheet, type “R1C1”. Now, in this article on UiPath Automation Examples let us move onto the next automation i. data() in the callback given to this method. May 1, 2002. One of the more powerful, but seldom used functions of Excel is the ability to very easily create automated tasks and custom logic within macros. Here's an example. Using Column Name along with DataRow Object Drag “Get Row Item” activity and supply the desired fields to it. Robotic Enterprise Framework configured and optimized to get the input data from a tabular data source, such as an Excel or CSV file. Words: The correct number of words are present in the output. Now since the default value of counter is zero get row item will read the first row but in video …. Youtube link UiPath link. DataView RowFilter Syntax [C#] This example describes syntax of DataView. So for every row item of my dtQuery, I add ASSIGN Activity that looks like this: row(2) = [item i want to add] But that doesn't answer my question. Note that in order to see the new row in the table you must call the draw() method, which is easily done through the chaining that the DataTables API employs. It takes a collection as an input and iterates through each row of it (number of rows corresponds to the number of times loop gets executed). DataTables stores the data for rows and columns in internal indexes for fast ordering, searching etc. Data Types, Arrays and Strings. Excel VBA Delete Sheet: Step-by-Step Guide and 6 Examples to Delete Sheets with Macros By J. I can't recall working on any actual-world RPA bot where I haven't used the loop stage. We saw a complete example of using DataView to sort rows in a DataTable. GetAttribute. Many times you need to extract your web table data to compare and verify as per your test case using selenium webdriver software testing tool. xlsx document? a). You can use the ROW and COLUMN functions to do this. Represents a row of data in a. Each row is a list of values, with each value representing a cell. You can add new items to a list using the Add To Collection activity (you will find it under Programming->Collection category). Hi all, I want to insert an array of values into a c# datatable without iterating the array. If you need to use the column letter for an output, you could make a small subroutine for this, but usually it's unnecessary. In the For-Each loop, we loop over each Row. Simple and Structured Data Types: A simple data type can store only one value at a time. data() in the callback given to this method. In Oracle Application Express, you can create check boxes as items, or you can create check boxes in reports. To get the row number, use the Reader object's line_num variable, which contains the number of the current line. If you have your data in a DataTable object and we want to retrieve specific data from a data table on some certain conditions, so it becomes quite easy to query a data table using its select method and Lamda Expression. Difference between Add queue items, get queue item & get transactions? Add Queue item-it is used for uploading data to queue. Add(DataRow) OR. is UiPath Explorer used for? a). Introduction to UiPath. VBA delete rows columns excel Macro helps automating delete the rows and column in Excel Worksheet using VBA code. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. I tried fnGetData(0) -- it seems to be returning the first item of raw table data before sorted by datatables Using firebug, I was able to get what I want like this:. 0, there are two different ways to construct a ForEach-Object command. Splitting and Manipulating Strings. Since a JSON structure is usually anonymous and doesn't necessarily have a "root member object" JSONPath assumes the abstract name $ assigned to the outer level object. Create four new Double variables sumCashIn, sumOnUsCheck, sumNotOnUsCheck and an Int32 variable. This adds an item to a queue (defined below at steps 8 and 12), for each row in the spreadsheet. kellywong911 if there is a better way to rewrite the codes as follows, When you are using string values, there is not much you can do. You can add new items to a list using the Add To Collection activity (you will find it under Programming->Collection category). For example, if you want to display all emails that have attachments, you can select Has Attachments or type hasattachments:yes in the Search box. object Description: Use different data for the different data types requested by DataTables (filter, display, type or sort). If you wish to tidy this up, you can switch off Field Headers and set Grand Totals to be Off for Rows and Columns. If you want to work with a collection that doesn't have a fixed number of elements, you can use a list instead of an array. In the For-Each loop, we loop over each Row. iI strongly recommend this institute for who is looking for job in Automation. I can't recall working on any actual-world RPA bot where I haven't used the loop stage. Compare the rows. so I have to get the value from the row with other method, all the tables has the same columnName and the tablesname are deferent, the the within the tables are simple strings, so I need to get a ramdon row for each table, I hope this helps, I have tried everything and anything works!!. To clear the search filter and view all items in the selected mail folder, click in the Search box, or on the Search tab, select Close Search. We can use Column property to get last used Column. The Reader object can be looped over only once. Loading Unsubscribe from. The Excel COLUMN function returns the column number for a reference. We saw a complete example of using DataView to sort rows in a DataTable. Learn about the fundamental parts of UiPath Studio and automation in general. Get the help you need online. 2005, 2008, 2008R2, 2012 and 2014. Get started with UiPath, a leading robotic process automation (RPA) tool. A List expands as you add new items to it. How do i Find row index in datatable using vb. ColumnIndex - The index of the column whose value is to be retrieved from the DataRow. Get the data for a row that was clicked upon:. I get error, Cant find column 55. Besides this, this video helps you understand, through practical exercises, how to use the most popular Excel activities such as Read Range, Write Range, Append Range, Sort Table, Read Cell and Write Cell, as well as DataTable activities such as For Each Row, Output Data Table, Get Row Item, Add Data Row and Build Data Table. Automate rule based business and IT processes. It also presents a WPF example on how to use this utility. If you wish to tidy this up, you can switch off Field Headers and set Grand Totals to be Off for Rows and Columns. Hello, for get row item activity’s properties - what do I type in row field? Hey @Serran_Neru. If you omit the argument for those formulas, the current cell is used. object Description: Use different data for the different data types requested by DataTables (filter, display, type or sort). data() available as this. These can be directly used with the OFFSET function, or any other function where you can specify both the row and column as numerical values. Now, in this article on UiPath Automation Examples let us move onto the next automation i. The utility should support multiple field sorting; The utility should be able to take. If you are going to attend UiPath RPA interview, then we are here to help you out with the frequently asked UiPath interview questions. The following examples demonstrate the use of the Item[String, DataRowVersion] property to get and set the value of a specific column index. We can use count the number of columns using in the active sheet from there we can come back in particular row to get the exact column with data. Change the language or guide from the left drop-down list. Data can likewise be updated with the row(). Excel VBA: Getting the Row Number of an Active Cell. The example pretty much gives out the way of using work queues. ColumnIndex - The index of the column whose value is to be retrieved from the DataRow. Here: We use the Rows indexer, Rows[0], to get the first row. Simple and Structured Data Types: A simple data type can store only one value at a time. You can populate this datarow and then add the row to the datatable using. Now select the Platform(s) column as your Row Labels. IO Module Module1 Sub Main() Dim i As Integer = 0 ' Loop through each line in array returned by ReadAllLines. Consider the following example using each(), which iterates over the row indexes that have been selected - we are required to get the row() object for each row to be able to work with it directly:. How do i Find row index in datatable using vb. Filter data by multiple criteria with Kutools for Excel Maybe the Advanced Filter feature is a little difficult for you, here, I have a powerful tool - Kutools for Excel , with its Super Filter utiltiy, you can filter data based on cell value with only one criterion or multiple criteria. Hi all, I want to insert an array of values into a c# datatable without iterating the array. The following example creates a new DataRow by calling the NewRow method of the DataTable object. Rows items = row than the above example except the result is returned as a. It allows you to sort your data before using it in your program, and before INSERT-ing it into your SQL database. Create four new Double variables sumCashIn, sumOnUsCheck, sumNotOnUsCheck and an Int32 variable. They enable you to perform all sort of actions ranging from reading PDF, Excel or Word documents and working with databases or terminals, to sending HTTP requests and monitoring user events. When my page comes up and the datatable is drawn, I want to get the first row of data. Besides this, this video helps you understand, through practical exercises, how to use the most popular Excel activities such as Read Range, Write Range, Append Range, Sort Table, Read Cell and Write Cell, as well as DataTable activities such as For Each Row, Output Data Table, Get Row Item, Add Data Row and Build Data Table. net? add the row to the DataTable & you cannot get the index until you add the new row to the table. Drag four Assign activities right after the Get Row Item activities. This sample extracts all the elements of a table. The utility should support multiple field sorting; The utility should be able to take. Please upgrade your browser. The utility should support multiple field sorting; The utility should be able to take. private void CreateNewDataRow() { // Use the MakeTable function below to create a new table. Here: The FirstWords method counts spaces in the input string. Macro Examples. If you omit the argument for those formulas, the current cell is used. 0, there are two different ways to construct a ForEach-Object command. You'll find comprehensive information about activities to help you get started as quickly as possible. I can't specify column names in my Code. We get the last row in the Rows collection by subtracting 1 from the Count. If you are using this blog post to pass your exam please re-consider using the following answers. Get the help you need online. Get Row Item. Say, for example, you have to build a table dynamically. As you strive to benefit in the Automation First. The cmdlet get-content is equivalent to cat in UNIX and returns the contents of the file as lines of text. If you wish to tidy this up, you can switch off Field Headers and set Grand Totals to be Off for Rows and Columns. Excel Application Scopeでsample. Requirement: User wants to paste his data for 5 Departments; Number of items in each row could be any thing between 1 to 15 (it is not fixed in all the rows). Many times you need to extract your web table data to compare and verify as per your test case using selenium webdriver software testing tool. hi, thanks for your effort, obviously this is a good way to create custom DataTable,my question is how to restrict the data to use only these columns, as in fill in the rows only and not add columns to it. In Oracle Application Express, you can create check boxes as items, or you can create check boxes in reports. Read Sheet2. For creating a project in uipath you will have to create a folder with your name and then select a particular location. We can pull up specific (or all) data items from it and continue with our process operations. The ForEach-Object cmdlet performs an operation on each item in a collection of input objects. Finding last used Column with data in particular Row – Example; Finding last used Column with data in particular Row – Case Study. English Subtitles. Documentation about Get Row Item and DataGridCellInfo Item from a Physical Point in UI for Windows 8 XAML. The print() function call prints the number of the current row and the contents of the row. If you want to work with a collection that doesn't have a fixed number of elements, you can use a list instead of an array. To get the row number, use the Reader object’s line_num variable, which contains the number of the current line. GetAttribute. 2 Tutorial 34:29 whole file and for each row, add a new item in the previously created queue. In order to retain one copy of the duplicates, simply paste the original text back into the first row that has been replaced by 1's. object Description: Use different data for the different data types requested by DataTables (filter, display, type or sort). The remaining rows are the data. Column A note on columns: In VBA, you usually end up working with column numbers. As listed above SQLite is known for its zero. Welcome to UiPath Academy! The world's first open online training platform for RPA users. Add(DataRow) OR. You can use it for your reference to excel in your UiPAth certification. K · Try String[] arr. You can add new items to a list using the Add To Collection activity (you will find it under Programming->Collection category). Highlighting a row is easy using CSS, but for column highlighting, you need to use a little bit of Javascript. data() and row(). Having some elementary knowledge of programming concepts like variables, if/else decisions, and loops would be helpful. Get Row Item. May 1, 2002. Create four new Double variables sumCashIn, sumOnUsCheck, sumNotOnUsCheck and an Int32 variable. Hmmm…looks like you are not referring RPA blogs and videos. 0, there are two different ways to construct a ForEach-Object command. Besides this, this video helps you understand, through practical exercises, how to use the most popular Excel activities such as Read Range, Write Range, Append Range, Sort Table, Read Cell and Write Cell, as well as DataTable activities such as For Each Row, Output Data Table, Get Row Item, Add Data Row and Build Data Table. Each row is a list of values, with each value representing a cell. data normally does. They are Basic, desktop, web, and Citrix. Tim provided the inspiration for a function that can return either the last row or column number through a user defined function for a given worksheet. If you are using this blog post to pass your exam please re-consider using the following answers. Drag four Assign activities right after the Get Row Item activities. 0:34 The UiPath robot runs the processes designed in UiPath Studio, the same. ColumnIndex - The index of the column whose value is to be retrieved from the DataRow. If you omit the argument for those formulas, the current cell is used. the Email Automation. As a UIPath newbie, thoughts on the best way to achieve this?. November 3, 2014; Sometimes, we need to get a row number of the current active cell. I know that this can be done if the data of the secondary data source is "dragged" to the InfoPath form as a Repeating table, the problem with this is that the data does not get saved in the form, so this last option doesn't work for me. Which of the following is a good example of a workflow name a specific cell from a row in a datatable?a). A developer may traverse through this collection one at a time and simply get the processing done. K · Try String[] arr. So for every row item of my dtQuery, I add ASSIGN Activity that looks like this: row(2) = [item i want to add] But that doesn't answer my question. It can be useful at times to know what these indexes are, as they can be used for efficient selectors in the row(), column() and other API methods which use selectors. Requirement: User wants to paste his data for 5 Departments; Number of items in each row could be any thing between 1 to 15 (it is not fixed in all the rows). Scraping multiple Pages using the Scraper Extension and Refine Many times you'll not have one single page to scrape. How to use Get Attribute activity. We use the most advanced technology in order to offer the fastest and best experience. To get the row number, use the Reader object's line_num variable, which contains the number of the current line. data() and row(). importance of data tables and how to create the data tables ,how to add data into data tables ,how to get the values by using get row item activity,how to de. DataView RowFilter Syntax [C#] This example describes syntax of DataView. You can use it for your reference to excel in your UiPAth certification. Please anyone give me the solution for that Prabhakaran. This adds an item to a queue (defined below at steps 8 and 12), for each row in the spreadsheet. So the new folder will get saved in the default directory. I am taking example of BluePrism and UiPath as they are popularly known. In order to retain one copy of the duplicates, simply paste the original text back into the first row that has been replaced by 1's. Get the help you need online. NET program that loops through row Module Module1 Sub Main() Dim table As DataTable = GetTable() ' Get first row. iI strongly recommend this institute for who is looking for job in Automation. What is UiPath RPA | Robotic Process Automation? We deliver the most advanced Enterprise #RPA Platform, built for business and IT. The print() function call prints the number of the current row and the contents of the row. When my page comes up and the datatable is drawn, I want to get the first row of data. Using Column Name along with DataRow Object Drag “Get Row Item” activity and supply the desired fields to it. SelectToken makes dynamic queries easy because the entire query is defined in a string. It takes a collection as an input and iterates through each row of it (number of rows corresponds to the number of times loop gets executed). Generic method: Field, part of DataRow, is a generic method. You can use it for your reference to excel in your UiPAth certification. Please paste in the GetTable method to run this program. I can't specify column names in my Code. Train and design robots that drive the user interface like a human. xlsx document? a). We will show some examples of how to use regular expression to extract and/or replace a portion of a string variable using these three functions. In simple terms this means you have the methods such as row(). K · Try String[] arr. All Get Row Item activities should have in the Row field the following text transactionsFiltered. tr DOM elements can be given as a row selector to select a row in the DataTabels API from that DOM element. I want to know the count of each unique item with 2 criteria - They are same DATE and ERROR. If you are looking for a more complete and easier to use row selection option, the Select extension provides an API that is fully integrated with DataTables for selecting rows and acting upon that selection. UiPath Robotic Process Automation tutorial step by step videos. Import row or using ItemArray to copy datarow from one datatable to another datatable [Answered] RSS 3 replies Last post Jan 29, 2013 02:01 AM by Ashish_Patel. Description. 37) In the UiPath Robotic Enterprise Framework template, in the Get Transaction Item state of the Main workflow, what happens before the next transaction item is retrieved? We check if the previous transaction has been completed; We check if a kill signal was sent from Orchestrator; We check if a stop signal was sent from Orchestrator. When I query this data, instead of getting 14 columns for row, I only get 13 columns and the data is incorrect due to lack of order. Which of the following is a good example of a workflow name a specific cell from a row in a datatable?a). The childNodes property returns a collection of a node's child nodes, as a NodeList object. Welcome to UiPath Academy! The world's first open online training platform for RPA users. Best Uipath Training in OMR I have completed my UiPath training in Karapakkam at Hope Tutors. We get the last row in the Rows collection by subtracting 1 from the Count. Please upgrade your browser. More than 1 year has passed since last update. The datagrid component contains two methods to retrieve selected row data: getSelected: Get the first selected row data, if no row selected return null else return the record. Unfortunately, your browser is outdated and doesn. Let's say this is your table and you want to get the distinct list of Platforms. It allows you to sort your data before using it in your program, and before INSERT-ing it into your SQL database. K · Try String[] arr. They enable you to perform all sort of actions ranging from reading PDF, Excel or Word documents and working with databases or terminals, to sending HTTP requests and monitoring user events. In the first video in UiPath academy get row item event is used. A List expands as you add new items to it. Highlighting a row is easy using CSS, but for column highlighting, you need to use a little bit of Javascript. NET program that loops through row Module Module1 Sub Main() Dim table As DataTable = GetTable() ' Get first row. If you think something can be improved, feel free to suggest edits. Words: The correct number of words are present in the output. I am taking example of BluePrism and UiPath as they are popularly known. Check if both DataTables have the same number of columns. Generic method: Field, part of DataRow, is a generic method. For Each item As Object In row1. This is the UiPath introductory training. Hello, for get row item activity’s properties - what do I type in row field? Hey @Serran_Neru. This is how it's done with UiPath:. I know that this can be done if the data of the secondary data source is "dragged" to the InfoPath form as a Repeating table, the problem with this is that the data does not get saved in the form, so this last option doesn't work for me. As most of the RPA tools work in same way, so learning anyone tool can be sufficient. What happens if you use a Read Range activity with the Range property set to "" (an empty string)? a). The following examples demonstrate the use of the Item[String, DataRowVersion] property to get and set the value of a specific column index. We can use count the number of columns using in the active sheet from there we can come back in particular row to get the exact column with data. You may be able to use linq where extension method to check for specific condition. More practice sessions has been provided for us to get excel in the tool. so I have to get the value from the row with other method, all the tables has the same columnName and the tablesname are deferent, the the within the tables are simple strings, so I need to get a ramdon row for each table, I hope this helps, I have tried everything and anything works!!. Am having datatable full of values fetched from database(the fields are SID,SNAME) from that datatable i need to select only few rowsfor example i need to select the rows containing SID in(101,102,109). I can't recall working on any actual-world RPA bot where I haven't used the loop stage. So for every row item of my dtQuery, I add ASSIGN Activity that looks like this: row(2) = [item i want to add] But that doesn't answer my question. The nodes in the collection are sorted as they appear in the source code and can be accessed by index numbers. dear, I would like to know how to use multiple “get row item” on Excel and use multiple “switch” function? when I use the 2nd “get row item”, it appears an exception saying that “Get row item : StringConverter cannot convert from System. The print() function call prints the number of the current row and the contents of the row. Skip navigation Sign in. Description. Now, in this article on UiPath Automation Examples let us move onto the next automation i. Excel VBA Delete Sheet: Step-by-Step Guide and 6 Examples to Delete Sheets with Macros By J. Get cell value based on row and column numbers with User Defined Function. Here: The FirstWords method counts spaces in the input string. Data can likewise be updated with the row(). We can use Column property to get last used Column. Excel VBA: Getting the Row Number of an Active Cell. It also works with large excel files. さて、Hello Worldが出来たところで次はExcelの操作について書いていきましょう。 Excelの入出力がプログラムっぽく出来るのもUiPathの良いところです。 例題としてExcel化されたQiitaの投稿の. If you want to remove duplicate cells (rather than entire rows of data), you may find the Remove Duplicate Cells page more straightforward. Insert a Pivot Table with the table as your data source. In Oracle Application Express, you can create check boxes as items, or you can create check boxes in reports. Here: We use the Rows indexer, Rows[0], to get the first row. 0:19 UiPath Studio is the designer tool used to create diagrams of business processes. xlsx document? a). It takes a collection as an input and iterates through each row of it (number of rows corresponds to the number of times loop gets executed). Steps to automate. DataTable - Adding, Modifying, Deleting, Filtering, Sorting rows & Reading/Writing from/to Xml In this article, I am going to explain how to Add, Modify, Delete, Sort, Filter rows of the DataTable and also loading data from xml and writing data into xm. 0:34 The UiPath robot runs the processes designed in UiPath Studio, the same. This article presents a small utility class to sort an "IEnumerable" of objects on multiple fields by the field names provided at the run time using Linq. The nodes in the collection are sorted as they appear in the source code and can be accessed by index numbers. The second example uses the DataTable object's NewRow method to create a new DataRow object with the schema of the DataTable. Read Sheet2. SelectToken makes dynamic queries easy because the entire query is defined in a string. For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet. Excel VBA Delete Sheet: Step-by-Step Guide and 6 Examples to Delete Sheets with Macros By J. Drag four Assign activities right after the Get Row Item activities. The input objects can be piped to the cmdlet or specified by using the InputObject parameter. UiPath Activities are the building blocks of automation projects. At the bottom of the page is an explanation of all the regular expression operators as well as the functions that work with regular expressions. May 1, 2002. When my page comes up and the datatable is drawn, I want to get the first row of data. Check if both DataTables have the same number of columns. I tried fnGetData(0) -- it seems to be returning the first item of raw table data before sorted by datatables Using firebug, I was able to get what I want like this:. When no reference is provided, COLUMN returns the column number of the cell which contains the formula. Having some elementary knowledge of programming concepts like variables, if/else decisions, and loops would be helpful. Are there any ways to achieve this?. It takes a collection as an input and iterates through each row of it (number of rows corresponds to the number of times loop gets executed). The first example uses the Rows property and prints the value of each column for every row. Read Sheet2. Orchestrator lets you manage the creation, monitoring, and deployment of resources in your environment. Documentation about Get Row Item and DataGridCellInfo Item from a Physical Point in UI for Windows 8 XAML. More than 1 year has passed since last update. Step 10: Execute this sequence by clicking on the Run button. For example the Chilean Government has a very nice transparency site and offers the income statistics for many departments - let's get them all!. For example: ColumnName1 ColumnName2 value1 35 value2 44 value3 10 Because I know that value 1, 2. You will have all the data associated with that employee. UiPath has closed a $568 million Series D funding round at $7 billion valuation, becoming one of the highest valued enterprise software companies in the world and cementing #RPA as the leading technology transforming companies in the Automation-First era. kellywong911 if there is a better way to rewrite the codes as follows, When you are using string values, there is not much you can do. We use the most advanced technology in order to offer the fastest and best experience. so I have to get the value from the row with other method, all the tables has the same columnName and the tablesname are deferent, the the within the tables are simple strings, so I need to get a ramdon row for each table, I hope this helps, I have tried everything and anything works!!. An example of how you could call this function to return the last row on the active worksheet would be written as: x = LastRowColumn(ActiveSheet, "Row"). I tried fnGetData(0) -- it seems to be returning the first item of raw table data before sorted by datatables Using firebug, I was able to get what I want like this:.