Hi All,
Good Morning.
I want to create a pivot table using 3 columns (Set ID)(in Row labels) with (Credit and Debit)(Values) from a excel sheet( which contains the multiple columns.
Can someone please help me to do the same? It would be very helpful.
Thanks in advance.
@ppr
Best Regards,
NK
arivu96
(Arivazhagan A)
September 3, 2021, 4:40am
2
1 Like
ppr
(Peter Preuss)
September 3, 2021, 8:02am
4
please provide always sample data and output sample for us. This helps us to process faster a case. Thanks
Hi,
I need to apply Pivot Table between the columns “Set ID” to get the values(Credit and Debit)Spice 30th.xlsx (97.0 KB)Spice Money Payments_SEP333’21.xlsx (210.0 KB)
I have Manually done(Pivot Table) But I need to be done through UIPath.
Please help me on the same
@ppr ,
Any Update on this please?
ppr
(Peter Preuss)
September 8, 2021, 8:54am
7
your samples are giving some douts. Please share 1 Excel with only 2 worksheets input, output.
Also have a look here:
UiPath.Excel.Activities.Business.CreatePivotTableX Creates a pivot table from a specified range or table to help you calculate, summarize, and analyze data. Once added, you can add pivot table fields as rows, columns, filters, or summary fields. The...
When Activity filter is tickend on for studioX Activities we also can use those activities
Pivot_Table.xlsx (102.6 KB)
Please find
ppr
(Peter Preuss)
September 8, 2021, 9:23am
9
It seems that you are looking for grouping the data and calculate some aggregations (e.g. SUM) to the group member.
How to do is described here:
This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data.
Introduction
Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items.
Lets have a look on following data:
[grafik]
A possible scenario could be:
Create a report containing following information:
the region code
the sum of CaseCount per RegionCode
t…
Its done.
Thanks for your time.
Pivot.xaml (8.8 KB)
Please find the flowchart .
system
(system)
Closed
September 11, 2021, 10:00am
12
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.