MarketplaceStudioActivityNovigo Solutions - Transpose DataTable

Create your first automation in just a few minutes.Try Studio Web

Novigo Solutions - Transpose DataTable

Novigo Solutions - Transpose DataTable

by Novigo Solutions

9

Activity

Downloads

3.6k

Sumesh M S
Posted 3 years ago

Hi Nithin,

Good day.

Are we using any log4j related packages in your package.

Thanks

Sumesh

Nithin Prabhu
Posted 3 years ago ago

Hi Sumesh,

I'm not using log4j in this activity pack.  I have made the source code of this project public. You can take a look at it here : https://github.com/nithinprabhu/NovigoSolutions.TransposeDataTable.Activities.

Regards,

Nithin

l l
Posted 4 years ago

You are using the XLSTAT trial version. Number of days remaining until the trial expires: 11

XLSTAT 2021.2.1.1128 - Descriptive statistics - Start time: 23/05/2021 at 12:17:56 / End time: 23/05/2021 at 12:17:57 / Microsoft Excel 16.04266

It seems that the service used is a trial product with output prompts?

Nithin Prabhu
Posted 4 years ago ago

Hi,

The activity is written using C# system libraries only and I have made the source code of this project public. You can take a look at it here : https://github.com/nithinprabhu/NovigoSolutions.TransposeDataTable.Activities

Regards,

Nithin

Jonathan O
Posted 5 years ago

Hello Nithin,

Thanks for making this package. Had a question regarding the "Transpose DataTable (DT)" activity, whenever I'm using it to transpose a 2 column DT into a new DataTable with template defined headers, I noticed that the first column & row contain the original DT's headers.

In my case, these are just placeholders for "Spec" | "Value" in the original one, however I don't want to keep them in the new DT when transposed. Is there a way t prevent it from capturing that and/or removing it after?

Nithin Prabhu
Posted 5 years ago ago

Hello Jonathan,

As per my understanding the First Row in the Input DT is the Header & this becomes the first column & the corresponding row in the output.

After you use the Transpose DataTable Activity you can use the Remove Data Column Activity on the Transposed DT with ColumnIndex Property set to 0. This you can prevent the header of the input DT from appearing as the first column in the output DT. 

Thanks,

Nithin

Publisher

Novigo Solutions

Visit publisher's page

Trusted Source

License & Privacy

BSD

Privacy Terms

Technical

Version

1.0.0

Updated

October 17, 2024

Works with

Studio: 20.4 - 22.10

Certification

Silver Certified

Support

Link: https://www.novigosolutions.com/

Business Hours: Mon-Fri 9 AM to 6 PM IST; Response time: 1 business day (24 hours); Resolution time: 15 days

Resources