How do i create pivot table with specific columns in excel

Help Activities
, ,
1

I want to create a pivot table with some of the columns in excel but I am getting an error. The code I am using and the errors are provided down below. Please let me now what is wrong.

asd=(From row In dt.AsEnumerable
Group row By Key= New With{
Key.Region= row.item(“name1”),
Key.Rep= row.item(“name2”)
}Into grp= Group
Select dt.LoadDataRow(New Object(){
Key.Region,
Key.Rep,
grp.Count()
},True)).OrderBy(Function(row) row.item(“name1”)).ThenBy(Function(row) row.item(“name2”)).CopyToDataTable

RemoteException wrapping System.ArgumentException: Input array is longer than the number of columns in this table.
at System.Data.DataTable.NewRecordFromArray(Object value)
at System.Data.DataRowCollection.Add(Object values)
at System.Data.DataTable.UpdatingAdd(Object values)
at System.Data.DataTable.LoadDataRow(Object values,
Boolean fAcceptChanges)
at lambda_method(Closure ,
VB$AnonymousType_12 ) at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext()
at System.Linq.Buffer1..ctor(IEnumerable1 source)
at System.Linq.OrderedEnumerable1.<GetEnumerator>d__1.MoveNext() at System.Data.DataTableExtensions.LoadTableFromEnumerable[T](IEnumerable1 source,
DataTable table,
Nullable1 options, FillErrorEventHandler errorHandler) at System.Data.DataTableExtensions.CopyToDataTable[T](IEnumerable1 source)
at lambda_method(Closure ,
ActivityContext )
at Microsoft.VisualBasic.Activities.VisualBasicValue1.Execute(CodeActivityContext context) at System.Activities.CodeActivity1.InternalExecuteInResolutionContext(CodeActivityContext context)
at System.Activities.Runtime.ActivityExecutor.ExecuteInResolutionContext[T](ActivityInstance parentInstance,
Activity1 expressionActivity) at System.Activities.InArgument1.TryPopulateValue(LocationEnvironment targetEnvironment,
ActivityInstance activityInstance,
ActivityExecutor executor)
at System.Activities.RuntimeArgument.TryPopulateValue(LocationEnvironment targetEnvironment,
ActivityInstance targetActivityInstance,
ActivityExecutor executor,
Object argumentValueOverride,
Location resultLocation,
Boolean skipFastPath)
at System.Activities.ActivityInstance.InternalTryPopulateArgumentValueOrScheduleExpression(RuntimeArgument argument,
Int32 nextArgumentIndex,
ActivityExecutor executor,
IDictionary2 argumentValueOverrides, Location resultLocation, Boolean isDynamicUpdate) at System.Activities.ActivityInstance.ResolveArguments(ActivityExecutor executor, IDictionary2 argumentValueOverrides,
Location resultLocation,
Int32 startIndex)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor,
BookmarkManager bookmarkManager,
Location resultLocation)

image

image
image438×585 12 KB

2

@Onur_Oz

It is saying that you are passing more values in array of load datarow

I think you have only 2 columns,but you are passing 3 values using load datarow

Can you check it once

3

thanks for answer. how can I do it. As you said, I have 2 columns.

4

@Onur_Oz

Before the query

use add datacolumn activity

Hope this helps

5

Hi @Onur_Oz

How about the following

image
image622×726 24.3 KB

Hope this helps!!