Get Index Row from a DataRow, not a Datatable n

[Naveen.Ch (NaWin)]

@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.

[Pablito (Pawel Wozniak)]

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

[Naveen.Ch (NaWin)]

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.

[lakshman (Ganta lakshman)]

@Naveen.Ch

Try this:

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

[Naveen.Ch (NaWin)]

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

[lakshman (Ganta lakshman)]

@lakshman

Try this:

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

@Naveen.Ch

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

[Naveen.Ch (NaWin)]

hi @lakshman
can i get any sample workflow

[lakshman (Ganta lakshman)]

@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)

[Naveen.Ch (NaWin)]

still not getting bro

[lakshman (Ganta lakshman)]

@Naveen.Ch

It should be greater than zero right .

[Naveen.Ch (NaWin)]

i am filtering the data and adding into queues bro