Store "First Empty Row" value to a variable and use the variable to another table cell scope

[taufiqh15 (Muhammad Taufiq)]

Hi Guys,

I want to store “First Empty Row” value to a variable and use the variable to another table cell scope, but i don’t know how to apply that because i am a beginner in UiPath Studio X

How to apply that, because i need the first empty row index and use it to another table cell scope in SAP

Thank you

[ashokkarale]

@taufiqh15 ,

Use Activities - Find First/Last Data Row (uipath.com) this will return you two things

1. First row index - See Save first row number as in the body of the activity.
2. Last row index - See Save last row number as in the body of the activity.

Get the Last row index in variable and increase it with Assign activity like

You are ready to use this variable wherever you want.

Thanks,
Ashok

[taufiqh15 (Muhammad Taufiq)]

Hi Ashok,

Thanks for your response, as i know find First/Last Data Row just applicable for excel, but in my case, i am using SAP which has a table of task operation and i can not find activities -find first/last data row for SAP Table

any another way?

Thank you

[raduc (Radu Coriu)]

Hi @taufiqh15!

It’s actually very easy. You just have to:

1. Go to the Properties panel on the right (you can pin it for easier usage)
2. Select the first Table Cell Scope activity from which you want to take the output
3. In the Properties panel, you’ll see two rows in the Outputs category, Table Row Index and UiElement. You just need the Table Row Index. Just click and create a new variable
4. In the second Table Cell Scope activity just use the variable from step 3.

[taufiqh15 (Muhammad Taufiq)]

Hi @raduc

Alhamdulillah, you save may team… Thank you for helping me