I have given several Excel files with reports. I’ve need to combine them all and create a pivot table. Please, help
There are pre-build activities to combine excel files such as merge and to create a pivot table there is an activity called to create a pivot table. Use those pre-built activities to build your work flow
If the files have same headers you can use merge datatable activity to merge the data into a single DT then for Pivot you can use a LinQ query or traditional loops and select function to achieve it. If you can provide some info about pivot then we can help you with some LinQ queries.
- You can use read range activity to read the datatables from the excel files
- If the structure of that datatables are same you can use merge activity to merge all the datatables into a single datatable.
- One you have datatable ready, you can refer this video to create the pivot table using linq
LINQ | LINQ Pivot | Create Pivot Table Using LINQ | LINQ Uipath | Uipath Tutorials | Coderslobby - YouTube
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.