Convert Columns data to row data and sum the data

Help Activities
, ,
#1

Hello @Marius_Puscasu ,
Good day.
I have an issue with one of the activities which you had provided from converting column data into row data.
The totals of each BU is not correct since I compared this with Pivot table. I am attaching the xaml file and the test file for your reference.
Convert columns into rows.xaml (3.6 KB) cd.xlsx (18.8 KB)

Appreciate your support on the same.
Regards,
Manjesh

#2

Hi @manjesh_kumar ,

Could you please upload the .xaml file again. The file uploaded within your previous message is quite empty.

Thank you!
Best regards,
Marius

#3

Hello @Marius_Puscasu

Sorry for that.
Convert columns into rows.xaml (11.6 KB)

Sorry also the net amount column should be Double.

Regards,
Manjesh

#4

Hi @manjesh_kumar,

The flow was updated by adding the following condition
UiPath

I’ve tested it ad it gives the rights results.
Please find here the file: TransposeDataInExcel.xaml (12.8 KB)

Hope it helps
Best regards,
Marius

1 Like
#5

Dear @Marius_Puscasu ,
I have incorporated the same in my activity and gives me desired results.

I have run the complete work flow and I am disappointed with my self since my activity takes about 45 minutes to complete the below activities mentioned below.

  1. downloads data from SAP. - Not included in the workflow
  2. Add 4 different columns
  3. Does a vlookup for 4 columns
  4. Filter rows based on certain conditions
  5. Converts the data from row to column data into Day sheet.
  6. Converts the data from row to column data into Month to day sheet.

I have to add few more steps to the above workflow, however I am not satisfied with my current workflow. I am not sure this will not be accepted by the end users. Please let me know how I can improve this workflow to run much more faster, so that this can set the base for other projects.

I am attaching the zip file with the workflow and my data.
RPA_TEST.7z (201.6 KB)

Appreciate your valuable inputs on the same.

Regards,
Manjesh

#6

Hi @manjesh_kumar ,

Except the fact that you are looping 4 times thru the same datatable, instead of looking only one time, your workflow looks fine.

I would keep only one loop thru the dsrDtOut datatable. Please see below:

UiPath
UiPath852×1198 115 KB

Updated file: DSR.xaml (90.6 KB)

Best regards,
Marius

1 Like
#7

Dear @Marius_Puscasu,

Thank you very much that works perfectly and it almost reduced the entire workflow from 45 mins to 20 mins.

Regards,
Manjesh

1 Like
#8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.