As I see some topics related to pivot in excel, I just thought of having a pivot table activity WITHOUT HAVING THE DATA IN TABULAR FORMAT. I discussed this earlier with people in the forum, but I don’t think it is started.
If the user reads the data from excel and store it in data table and pass it to the activity, (Make sure the first rows and columns are the headers), the user has to provide the information of the column names which needs to be pivoted as --> columns which needs to be in rows, columns, measures and filters that are required in the pivot. Then just writing the pivot in another sheet or the new sheet based on the user requirement.
Is it possible to have this option? I have started the code development for this, but I was not able to finish it as I’m bust with multiple tasks now. Can anybody start this from beginning and have the activity?