Assign: There is no row at position -1 error

Help Studio
1

image
Book1.xlsx (159.2 KB)
Map_Date.xls (65.5 KB)
I am trying to map currency column from Map date sheet to Book 1 sheet but it is giving this error

Forum Engagement Daily Reports
2

Hi @bhanu.priya2 ,

Could you let us know the expression used in Assign activity ?

3

image
image1023×335 13.4 KB

4

@bhanu.priya2,

I think your datatable is empty. Check the rows availability.

Thanks,
Ashok :slight_smile:

5

it is not empty, i have attached the files please check

6

Hi @bhanu.priya2

You can check your input excel file the Currency column is empty that’s why it was throwing the error, check in the below image,
image

You have mentioned the Currecy column name in the expression, If the Currecy column is empty it will throw the There is no row at position -1 error.

Hope you understand!!

7

but i want to map the values into currency column only

8

which column values you want to map to Currency Column… @bhanu.priya2

Could you be more specific…

9

@bhanu.priya2 ,

Could you maybe add a breakpoint on Assign activity and check the values of all the variables used in Debug mode using Immediate panel and confirm the data availability ?

intIndex variable seems to be -1, but index starts from 0.

More on Debugging :

10

I want to map currency column values from sheet 2 to sheet 1 based on asset code
Sheet 1

image
image779×245 7.19 KB

Sheet 2
image

11

i changed it to 0 and tried it dint work

12

here is the attached file, someone please help
Map_Date.xls (65.5 KB)
Book1.xlsx (159.2 KB)

13

@bhanu.priya2 ,

We would like to know about other checks if it was done ? Debugging and checking other variable values ?

Also, The error message is not mentioned, was it the same error or a different message ? The change in error messages are also important to be noticed.