Error : Pivot Datatable: A value of type 'System.String' cannot be set to the location with name 'Result' because it is a location of type 'System.Data.DataTable'

Help
, ,
1

hi,
I am getting the below error when using excel pivot activity.
Error : Pivot Datatable: A value of type ‘System.String’ cannot be set to the location with name ‘Result’ because it is a location of type ‘System.Data.DataTable’

image

some one please help me out.

2

image
image

3

Well I believe variable ‘SallIncPivotTable’ is of string type. Output only accepts the variable in DataTable type, so I suggest you to convert ‘SallIncPivotTable’ to type ‘DataTable’.

I believe that’ll help you out.

4

No its a data table only. I was some data type issue inside the table. Thanks

5

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