Get Index Row from a DataRow, not a Datatable n

Help
1

@vvaidya @ClaytonM @Madhavi @loginerror @ovi @PrankurJoshi @arivu96

Hello Everyone,
I use the Framework Template, and here in the first stage i extract DataTable from a Excel File and transform in DataRow. The problem appear when I need the Index Number from a DataRow. Without a loop. Please Help.

2

Hi @Naveen.Ch,
Can you describe a little the process in which you need to get current index number of a row?

1 Like
3

Hi @Pablito

Thank you for your response ,
I need to transform from data table in DataRow because i work with FrameWork Template and if you rememeber i need to transform the DataTable in DataRow to take every time a row and process him, not in a loop. I hope you understand.

1 Like
4

@Naveen.Ch

Try this:

int index = TransactionData.Rows.IndexOf(TransactionItem)+2

5

hi @lakshman

thanks for the response i am not getting autosuggestion .rows.index

because it is alraedy converted into datarow i am adding the data into queues for refrence i have to add index to update the status in excel in performer

6

@Naveen.Ch

Here, TransactionData = your input dataTable
TransactionItem = one data row from data table

2 Likes
7

hi @lakshman
can i get any sample workflow

8

@Naveen.Ch

Please find the attached workflow. It is for reference purpose only. Based on this you can develop it.

GetTransactionData.xaml (9.4 KB)

9

still not getting bro

1
1775×512 45.9 KB

10

@Naveen.Ch

It should be greater than zero right .

image

11

i am filtering the data and adding into queues bro
2