How to loop each item from the table

Help
1

Hi all,
I have a table name Passenger where I have a column name Id_Number.
In the Id_number column, I have given 10 ids. so reading this id from this column and putting in an application. can anyone help how can I do this? Please help.
Generally, How to loop this. I want to picup this id number one by one and use into the type into activity.

1 Like
2

Hi
@balkishan

Buddy
-Use for each row loop and pass the datable as input
-inside the loop use type into activity pass the value as
Row(“column name”).tostring or
Row(“column index”). tostring
(Here Row is for each row variable name…you can even keepyour name as u like)

Hope this would help you

Cheersf

3

I am interacting with the oracle database bro, Is sql and oracle db query same.

4

@balkishan
Yah you can use execute query activity with which u can access any db servers…
The output would be in datatable type
You can use this activity buddy

5

Is it fine what you said bro.
image

1 Like
6

@balkishan

In Type Into activity, write like this:

row(“ColumnName”).Tostring

2 Likes
7

@balkishan
Buddy You can either use column name like Row(“column name”).tostring
Or
Row(columnindex). tostring

Cheers…

1 Like
8

Okay, Thanks bro :slight_smile:

9

Directly from data table you can list like this if your select query return single row.

SingleUserDT.Rows(0).Item(1).ToString()