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)
Appreciate your valuable inputs on the same.