DataTable Transpose without looping

Help
1

Hi, is there an efficient way to transpose rows to columns of a datatable without looping through every single row? This is to speed up the workflow when working with large data sets

E.g.

Title,Value
Title1,Value1
Title2,Value2
Title3,Value3

Transposes to:

Title1,Title2,Title3
Value1,Value2,Value3

Note that the headers in the first table are removed, the first column becomes the new headers

If you need to use looping, please post the solution here as well

2

@DEATHFISH

Install below package and then use Transpose DataTable activity. This activity will help you to convert rows to columns and vice versa.

2 Likes
3

Hi, the production machines will most likely be behind a firewall that won’t allow me to download custom packages, do you have suggestions on how I should build a transpose DataTable workflow of my own?

4

@DEATHFISH

If possible download into your local machine and then copy that package into production machine.

And also you can download it from Uipath studio also. Just search for DataTable.Activities package.

2 Likes