How to create pivot table and drag the fields in the boxes
You can use the existing activity to create a pivot table. Before that, you need to create a data table with the required columns in it.
Or else, you need to write VB code to do that
Can you send me any sample pivot table and data table with any columns in it
You want it with existing activities or code?
existing activity…if possible code too
Here is the best example for creating pivot table @venkateshtangudu,
Create Pivot Table.zip (19.3 KB)
Check this link for code to create a pivot table :
thanks i will check
Let me know if you have any doubts and make sure your excel data is in the tabular format and has the table name . Then you have to give that table name in the create pivot table activity
i understood, can we drag the pivot table fields…!in filter,columns,rows and values automatically
Existing activity will take them based on the data types but you can do that using code.
Check the code. It has everything and let me know if you have doubts
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.