Getting error for type into Activity where Input for tye into activity is taken from Row of Datatable variable

Help Activities
, , , ,
1

Hi All Friends,

i am getting error for type Into activity as Type Into ‘INPUT’: Column ‘Email’ does not belong to table Sheet1. for this Type Into activity input is taken from row of Datatable variable.
1)firstly the data is read from excel and stored in Datatable variable and then
2) using for each row activity for datatable each row is taken as input and entered the data . but for type into activity it is throwing error as Type Into ‘INPUT’: Column ‘Email’ does not belong to table Sheet1. Please tell me solution for this error..Please find attached screenshot for this error.

Error for Type Into Activity
Error for Type Into Activity1926×1080 187 KB

Thanks and regards,
Varun Shinde

2

@varun_shinde1

Can you check in the Excel sheet if the column name is exactly “Email” without any white spaces

If that is the same then check in Read Range that if you have enabled the Add Headers property

Hope this will help you

Thanks

3

Hi Srini,

it is still giving the error.

image
image1920×1080 205 KB

4

Hi @varun_shinde1 ,

As you are Already in the Debug Mode, we would suggest you to Check the Value of the Datatable being used in the Locals Panel.

We would be able to Check the Column Names from that.

5

Hi Arpan,

Please find value of Datatable variable in attached.

image
image1920×1080 215 KB

6

@varun_shinde1

As you see that It’s not taking Email,Mobile,Status as headers

Can you show the Read Range activity Properties?

Thanks

7

@varun_shinde1

Check as below

image
image880×210 12.3 KB

Hope this will help you

Thanks

8

Hi @varun_shinde1 ,

As mentioned by @Srini84 ,

Probably you have not Enabled Add Headers Property in the Read Range Activity, Hence, By Default we get the Column Names as Column1, Column2,...

Check the Add Headers and Let us know if you are still facing the same issue

9

Hi Srini,

it will still give the same error because previously it was cecked as "“Headers”

10

@varun_shinde1

Can you share your Read range activity with Properties and excel file as well?

Thanks

11

@varun_shinde1 Could you Check your Excel File, if you have a Space after the Email word ?

From the Debug Output, It looks as if there is a Space. Check and Let us know if that is the Case.

12

it is working now .thanks so much Bro !!!

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.