How to dynamically read an specific cell from a large number of data

[Tanzill_Ahsan]

I want to read the last most data from the column Balance and this column size is dynamic. Is there any solution available from where I can remake it for my own solution?

Or any possible idea to solve this case?

Thank you

[Shraddha_Gore]

Hi @Tanzill_Ahsan ,

Try below assignment.

Balance = YourDT(YourDT.Rows.Count - 1)(“Balance”)

[prasath_S]

Hi @Shraddha_Gore

I think it should be first row and then column ,

Balance = YourDT(YourDT.Rows.Count - 1)(“Balance”)

[Shraddha_Gore]

Hi @prasath_S ,

Thank you for correcting me.
I interchanged row & column by mistakely.

[Tanzill_Ahsan]

Should I write this code under for each row loop?

[prasath_S]

Write it in assign activity.

[Tanzill_Ahsan]

Thank you