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
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.
downloads data from SAP. - Not included in the workflow
Add 4 different columns
Does a vlookup for 4 columns
Filter rows based on certain conditions
Converts the data from row to column data into Day sheet.
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)