How to optimize write datatable transposing in excel format

Help Activities
, ,
1

Hi,

I have a workflow attached below, the current workflow can be seen in file below :

Masked Workflow Fix.xaml (46.1 KB)
Transpose - Copy.xlsx (9.7 KB)

The current workflow is working as the expected output in the Transpose-Copy excel file. The problem is, the sequence transpose_ColumnsToRows is running for 1 hour and 15 minutes, and my goal to run the robot is max 30 minutes (if 35 minute it still tolerable). Can the current workflow be more simplified so the robot running faster? I am stuck in this so anyone might be can help? Thanks

1 Like
2

Hey @Rhys18

What’s the amount of data being passed here ?

Thanks
#nK

3

Around 600.000 data processed (raw data, so there are so many duplicates) and the output data is around 19.000-20.000

4

Hey @Rhys18

The count doesn’t look that big.

Could you please show a snap of your transpose logic ?

Thanks
#nK

5

The logic is in the workflow I attach at the post. You can see it much clearly than just a snap of screenshot :slightly_smiling_face:

6

Anyone can help me with this?

7

You can use database for fast result

8

What do you mean by database?

1 Like