Pivot

Help Activities
1

Hi friends,

I have an excel with columns A to S, column A has Reference Number, Column R has Amount and column S has vlookup value.

I need to do pivot operation on Reference number and get the count and sum of Amount of that Reference number.

The same I need to do pivot on vlookup value and get the count and sum of Amount of vlookup value.

Can you please help me in this.
I don’t know how to go with this

2

@hanviprebday

Use create pivot table activity…and define the column rows and aggregates you need

A small tutorial…it works the same way in studio as well

Hope this helps

Cheers

3

Hi @hanviprebday
Try this:

image
image880×1053 52.1 KB

Hope it helps!!

4

@Parvathy
I am using classic version can you please help me with that flow

5

@hanviprebday

Here is a classic activity with example

Cheers

6

Hi @hanviprebday ,

Thanks for reaching out to UiPath community.

Use the “Read Range” activity to read the Excel file into a DataTable.

Use LINQ or GroupBy in UiPath to group the data by Reference Number, then calculate the count and sum of the Amount.

Create a new DataTable or Excel sheet to store the pivoted data.

Similar to the Reference Number, group the data by the Value column and calculate the count and sum of the Amount.
Store this pivoted data in a separate DataTable or Excel sheet.

Thanks,
@pratik.maskar

7

How to use linq or groupby I don’t have idea