# \#datarow **URL:** https://forum.uipath.com/tag/datarow/2278.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [Unable to do operations with data row](https://forum.uipath.com/t/unable-to-do-operations-with-data-row/741731)
**Author:** [@Murthy\_Desineedi\_Radhakri](https://forum.uipath.com/u/Murthy_Desineedi_Radhakri)\ **Replies:** 1\ **Last updated:** [May 17, 2024, 5:25pm UTC](https://forum.uipath.com/t/unable-to-do-operations-with-data-row/741731 "2024-05-17T17:25:52Z")
Hi All, I want to perform a task with data I have. I have a excel and its called as database. We have a one column called “Deal ID”, which has duplicates. I have another data table(we can call this as outputdt) where we … --- ## [Finding non-matching datatable rows (multiple columns)](https://forum.uipath.com/t/finding-non-matching-datatable-rows-multiple-columns/584905)
**Author:** [@sam.willson](https://forum.uipath.com/u/sam.willson)\ **Replies:** 4\ **Last updated:** [September 14, 2023, 8:30am UTC](https://forum.uipath.com/t/finding-non-matching-datatable-rows-multiple-columns/584905 "2023-09-14T08:30:31Z")
Hi there, I’m currently trying to compare two datatables, and return the items from one DT that don’t match. E.g Datatable 1 - “NewClientData” Datatable 2 - “ExistingClientData” I’m trying to use the following… --- ## [Error due to spaces](https://forum.uipath.com/t/error-due-to-spaces/576947)
**Author:** [@P-A-J](https://forum.uipath.com/u/P-A-J)\ **Replies:** 7\ **Last updated:** [August 30, 2023, 4:39pm UTC](https://forum.uipath.com/t/error-due-to-spaces/576947 "2023-08-30T16:39:00Z")
i am using a assign to a DataRow variable. dtTable2.Select(“Emp Id=”+SelectRows(“ID”).ToString)(0) this is giving me error , saying “Assign: Syntax error: Missing operand after ‘Id’ operator” The expression “SelectRow… --- ## [Split datatable variable by Nth occurance of character](https://forum.uipath.com/t/split-datatable-variable-by-nth-occurance-of-character/574680)
**Author:** [@sam.willson](https://forum.uipath.com/u/sam.willson)\ **Replies:** 7\ **Last updated:** [August 22, 2023, 3:45pm UTC](https://forum.uipath.com/t/split-datatable-variable-by-nth-occurance-of-character/574680 "2023-08-22T15:45:12Z")
Hi there, Does anyone have any advice on how I can split the data in my datatable by the Nth variance of a character, and then add the new split data to a new row? I would like to split my data by the 2nd occurrence of… --- ## [DataRowから特定の文字が含まれる列を探す](https://forum.uipath.com/t/datarow/523845)
**Author:** [@111860](https://forum.uipath.com/u/111860)\ **Replies:** 3\ **Last updated:** [March 8, 2023, 7:39am UTC](https://forum.uipath.com/t/datarow/523845 "2023-03-08T07:39:05Z")
質問 下記のようなdatarow型のうち、例えば「鋼材費」が含まれる列名の数量（例の場合はカラム2数量）を取得する方法はありますか？ カラム1,カラム1数量,カラム2,カラム2数量,カラム3,カラム3数量 設備費,10,鋼材費,5,木材費,15,照明,20 --- ## [Data table displaying as string, would like to convert to rows](https://forum.uipath.com/t/data-table-displaying-as-string-would-like-to-convert-to-rows/515491)
**Author:** [@james.althoff](https://forum.uipath.com/u/james.althoff)\ **Replies:** 5\ **Last updated:** [February 10, 2023, 4:32pm UTC](https://forum.uipath.com/t/data-table-displaying-as-string-would-like-to-convert-to-rows/515491 "2023-02-10T16:32:02Z")
I am extracting data tables from a PDF. So far, I can extract the data table, but when I try to write to excel it will have the separate columns, but it will put all of the data from each column into one row. How do I ge… --- ## [Doubt about the use of reframework with data rows](https://forum.uipath.com/t/doubt-about-the-use-of-reframework-with-data-rows/514289)
**Author:** [@Lynx](https://forum.uipath.com/u/Lynx)\ **Replies:** 4\ **Last updated:** [February 6, 2023, 5:15pm UTC](https://forum.uipath.com/t/doubt-about-the-use-of-reframework-with-data-rows/514289 "2023-02-06T17:15:17Z")
Good afternoon friends; I am learning the use of the UiPath ReFramework, but I have some doubts. The first thing to do is to change TransactionItem from queue to datarow, to be able to test it in excel, but it generate… --- ## [How to extract complete DataRow given using Linq?](https://forum.uipath.com/t/how-to-extract-complete-datarow-given-using-linq/473123)
**Author:** [@Muralikrishna\_Surve](https://forum.uipath.com/u/Muralikrishna_Surve)\ **Replies:** 5\ **Last updated:** [September 15, 2022, 7:28am UTC](https://forum.uipath.com/t/how-to-extract-complete-datarow-given-using-linq/473123 "2022-09-15T07:28:01Z")
I want extract complete “skills” row value one by one from excel using Linq. how to achieve this ? --- ## [In Re-Framework DataTable to DataRow](https://forum.uipath.com/t/in-re-framework-datatable-to-datarow/462495)
**Author:** [@yigit.aybey](https://forum.uipath.com/u/yigit.aybey)\ **Replies:** 2\ **Last updated:** [August 4, 2022, 1:59pm UTC](https://forum.uipath.com/t/in-re-framework-datatable-to-datarow/462495 "2022-08-04T13:59:11Z")
Hi all, I’m doing a assignment without orchestrator connection in Re-Framework. I’m doing datascrapping and excel works in initPart. But when i run the program it happend a problem in get transaction data which was abo… --- ## [Code returning wrong value in output file](https://forum.uipath.com/t/code-returning-wrong-value-in-output-file/456446)
**Author:** [@Dhruvi\_Arumugam](https://forum.uipath.com/u/Dhruvi_Arumugam)\ **Replies:** 1\ **Last updated:** [July 14, 2022, 10:17am UTC](https://forum.uipath.com/t/code-returning-wrong-value-in-output-file/456446 "2022-07-14T10:17:52Z")
Hi Everyone, Urgent Require help in the below scenario !!! I had a case where I wanted to merge csv files into a single CSV file, above solution was provided to me and it was working fine for merging. But post mergi… --- ## [How to replace a column/row value in datatable in Uipath (based on some condition) without using for each row](https://forum.uipath.com/t/how-to-replace-a-column-row-value-in-datatable-in-uipath-based-on-some-condition-without-using-for-each-row/453327)
**Author:** [@MariaJosephina](https://forum.uipath.com/u/MariaJosephina)\ **Replies:** 6\ **Last updated:** [July 4, 2022, 7:46am UTC](https://forum.uipath.com/t/how-to-replace-a-column-row-value-in-datatable-in-uipath-based-on-some-condition-without-using-for-each-row/453327 "2022-07-04T07:46:04Z")
Hi All, I have a dataTable with 3 columns Column1, Column2 and Column3 with 100 rows. Column1 Column2 Column3 123 hello GoodMorning 765 heloon GoodNight 134 hey Goo… --- ## [How to edit value in data table or in data row in debug mode?](https://forum.uipath.com/t/how-to-edit-value-in-data-table-or-in-data-row-in-debug-mode/422016)
**Author:** [@vigneshnkv](https://forum.uipath.com/u/vigneshnkv)\ **Replies:** 4\ **Last updated:** [May 10, 2022, 8:10am UTC](https://forum.uipath.com/t/how-to-edit-value-in-data-table-or-in-data-row-in-debug-mode/422016 "2022-05-10T08:10:13Z")
Hi, When debugging the code, I can edit the string variable value/ Int variable value. But If I edit a value in data row or data table, that is not reflecting. How to edit that? Example: Opening data row for editing … --- ## [How to get the row number in an excel file depends on specific cell](https://forum.uipath.com/t/how-to-get-the-row-number-in-an-excel-file-depends-on-specific-cell/416711)
**Author:** [@chrisjiyiwei](https://forum.uipath.com/u/chrisjiyiwei)\ **Replies:** 1\ **Last updated:** [April 21, 2022, 1:45am UTC](https://forum.uipath.com/t/how-to-get-the-row-number-in-an-excel-file-depends-on-specific-cell/416711 "2022-04-21T01:45:47Z")
dear all i have a problem to solve it, and hope anybody could help me . i have an excel file , as the following figure in Row A , the 69th row is 2022-4-21 (the content of cell A69) , how could I get the row numb… --- ## [How to only take certain count for datarow array](https://forum.uipath.com/t/how-to-only-take-certain-count-for-datarow-array/412200)
**Author:** [@mashy2](https://forum.uipath.com/u/mashy2)\ **Replies:** 4\ **Last updated:** [April 4, 2022, 4:12am UTC](https://forum.uipath.com/t/how-to-only-take-certain-count-for-datarow-array/412200 "2022-04-04T04:12:48Z")
hi, this is my select datarow: DtPhase2.Select(“\[Order No\] ='”+OrderNoTest+“’ AND \[Sample ID\] is null”) This return 26 datarow. How to have datarow retrieve specific number. For example the datarow only return 3. --- ## [How to retrieve the correct data in the data table and typed it into the value for Type Into activity](https://forum.uipath.com/t/how-to-retrieve-the-correct-data-in-the-data-table-and-typed-it-into-the-value-for-type-into-activity/404493)
**Author:** [@\_waysi](https://forum.uipath.com/u/_waysi)\ **Replies:** 6\ **Last updated:** [March 4, 2022, 3:32pm UTC](https://forum.uipath.com/t/how-to-retrieve-the-correct-data-in-the-data-table-and-typed-it-into-the-value-for-type-into-activity/404493 "2022-03-04T15:32:24Z")
Here is the scenario. I have a tsv file with data and it was stored in a data table. Sample data in data table (sample\_dt) |Column1|Column2|Column3|Column4| |DataA1|DataA2|DataA3|DataA4| |DataB1|DataB2|DataA3|DataB4… --- ## [How to get specific data from data table and make it as value to be typed in TypeInto activity](https://forum.uipath.com/t/how-to-get-specific-data-from-data-table-and-make-it-as-value-to-be-typed-in-typeinto-activity/404365)
**Author:** [@\_waysi](https://forum.uipath.com/u/_waysi)\ **Replies:** 14\ **Last updated:** [March 4, 2022, 9:57am UTC](https://forum.uipath.com/t/how-to-get-specific-data-from-data-table-and-make-it-as-value-to-be-typed-in-typeinto-activity/404365 "2022-03-04T09:57:40Z")
Hi, Would like to ask for your help on how will i be able to get the specific value in the data table and put it as value in the TypeInto activity? Because I’m getting an error that every loop. I always the the value in… --- ## [Adding DataRow in between of datatable -- Help](https://forum.uipath.com/t/adding-datarow-in-between-of-datatable-help/363228)
**Author:** [@Anjali\_Rani](https://forum.uipath.com/u/Anjali_Rani)\ **Replies:** 8\ **Last updated:** [November 21, 2021, 4:16pm UTC](https://forum.uipath.com/t/adding-datarow-in-between-of-datatable-help/363228 "2021-11-21T16:16:00Z")
Hi, I have an excel sheet in which I have to add one row in second position with values, How can i achieve this! Please Help TestSS:- output should be: I don’t want to add 2nd row in start, After execution of wh… --- ## [Adding Data in same column again and again](https://forum.uipath.com/t/adding-data-in-same-column-again-and-again/354591)
**Author:** [@Anjali\_Rani](https://forum.uipath.com/u/Anjali_Rani)\ **Replies:** 8\ **Last updated:** [October 20, 2021, 5:12pm UTC](https://forum.uipath.com/t/adding-data-in-same-column-again-and-again/354591 "2021-10-20T17:12:15Z")
Hi, can anyone help me into this, i have to process the data result should be write 5 times in same column Like for Last name data there are 5 values and all appropriate values should be written only in 1 last name col… --- ## [Error using datarow as argument](https://forum.uipath.com/t/error-using-datarow-as-argument/322781)
**Author:** [@D\_Okthree](https://forum.uipath.com/u/D_Okthree)\ **Replies:** 1\ **Last updated:** [June 15, 2021, 11:26am UTC](https://forum.uipath.com/t/error-using-datarow-as-argument/322781 "2021-06-15T11:26:38Z")
Hi Experts, I got an issue when I’m using datarow variable as a argument. The default value is null and when I was trying to execute, I got error: VisualBasicValue: Object reference not set to an instance of an object…