# DataRowの検索について

**URL:** <https://forum.uipath.com/t/datarow/149186>\
**Category:** Help\
**Tags:** system, activities\
**Created:** [September 9, 2019, 12:00pm UTC](https://forum.uipath.com/t/datarow/149186 "2019-09-09T12:00:10Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![rena168](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@rena168](https://forum.uipath.com/u/rena168)\
**Post date:** [September 9, 2019, 12:00pm UTC](https://forum.uipath.com/t/datarow/149186/1 "2019-09-09T12:00:10Z")

</div>

[Book1.xls](https://forum.uipath.com/uploads/short-url/9XuXh00T6ADmKpsbuFLEnSRZXgN.xls) (17.5 KB)

データテーブルの行の固有内容と、インプットダイアログから月を入力した該当列のデータをもとに  
新規のデータテーブルを作成したいのですが、  
DataRowの中でのループがうまくできません。

何か良い方法はありますか？

---

<div class="post-metadata">

**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\
**Post date:** [September 9, 2019, 12:06pm UTC](https://forum.uipath.com/t/datarow/149186/2 "2019-09-09T12:06:38Z")

</div>

> [@rena168](#):
>
> データテーブルの行の固有内容と、インプットダイアログから月を入力した該当列のデータをもとに  
> 新規のデータテーブルを作成したいのですが、  
> DataRowの中でのループがうまくできません。
> 
> 何か良い方法はありますか？

Fine  
we can use BUILD DATATABLE ACTIVITY to create a new datatable with columns we want and get the output with a variable of type datatable named outdt  
–now use a excel application scope and pass the file path of excel as input  
–inside the scope use a read range activity and get the output with a variable of type datatable named dt  
–now use a for each row loop and pass the variable dt as input  
–inside the loop use a if condition and validate the column value we want  
**row(“yourcolumnname”).tostring.equals(“yourvalue”)**  
if the condition passes it will go to THEN part where we can use a activity called ADD DATAROW activity where in the datatable mention as outdt and in the ArrayRow property mention as **row.ItemArray** in the property panel of add data row activity

hope ths would helpyou  
Cheers @rena168

---

<div class="post-metadata">

**Author:** ![rena168](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@rena168](https://forum.uipath.com/u/rena168)\
**Post date:** [September 9, 2019, 1:08pm UTC](https://forum.uipath.com/t/datarow/149186/3 "2019-09-09T13:08:27Z")

</div>

I want to know find tha “yourvalue”'s index in row.  
Please help me!  
Thanks you very much!

---

<div class="post-metadata">

**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\
**Post date:** [September 9, 2019, 1:12pm UTC](https://forum.uipath.com/t/datarow/149186/4 "2019-09-09T13:12:07Z")

</div>

no worries  
i meant yourvalue as the the column value that we want to validate  
Cheers @rena168

---

<div class="post-metadata">

**Author:** ![rena168](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@rena168](https://forum.uipath.com/u/rena168)\
**Post date:** [September 10, 2019, 12:04am UTC](https://forum.uipath.com/t/datarow/149186/5 "2019-09-10T00:04:49Z")

</div>

Hi,Thanks.  
How can i get has **“yourvalue”**'s index in row?

use indexOf?  
But this method can not.

---

<div class="post-metadata">

**Author:** ![rena168](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@rena168](https://forum.uipath.com/u/rena168)\
**Post date:** [September 10, 2019, 12:41am UTC](https://forum.uipath.com/t/datarow/149186/6 "2019-09-10T00:41:52Z")

</div>

以下が、カラムの列です。  
例えば、４月を入力したら、その月の値はこれで取得できました。  
**row（ “4月” ）.tostring.equals（ “yourvalue”）**  
しかし、４月の関連データ（Column1,Column2,Column3,Column4,Column5）も取得したいです。  
そのため、row（ “4月” ）のindexを取得したいです。

```
4月,Column1,Column2,Column3,Column4,Column5,5月,Column6,Column7,Column8,Column9,Column10,6月,Column11,Column12,Column13,Column14,Column15,7月,Column16,Column17,Column18,Column19,Column20,8月,Column21,Column22,Column23,Column24,Column25,9月,Column26,Column27,Column28,Column29,Column30,10月,Column31,Column32,Column33,Column34,Column35,11月,Column36,Column37,Column38,Column39,Column40,12月,Column41,Column42,Column43,Column44,Column45,1月,Column46,Column47,Column48,Column49,Column50,2月,Column51,Column52,Column53,Column54,Column55,3月,Column56,Column57,Column58

```

---

<div class="post-metadata">

**Author:** ![rena168](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@rena168](https://forum.uipath.com/u/rena168)\
**Post date:** [September 10, 2019, 4:46am UTC](https://forum.uipath.com/t/datarow/149186/7 "2019-09-10T04:46:34Z")

</div>

Hi, I got it.  
I use DataTable.cloumns.indexof, to get indexOf.  
Thank you!

---

<div class="post-metadata">

**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\
**Post date:** [September 10, 2019, 5:56am UTC](https://forum.uipath.com/t/datarow/149186/8 "2019-09-10T05:56:11Z")

</div>

Great  
Cheers @rena168