How to transpose a table in DataManager

indranildatta · March 18, 2011 5:25AM

Hi,

I have a requirement to transpose a data table i.e. show the columns as rows and rows as columns, in DataManager. I am presuming that a combination of pivot and de-pivot operations can get me there, but I cannot quite nail it. It would be really great to hear if someone has accomplished this already and how. An example IOK file with the series of operations done on a small table would be ideal.

Cheers!
Indranil.

steve · March 18, 2011 5:40AM

A "Transpose" operation hasn't yet been developed. I don't think you're going to have any luck with pivot and de-pivot. Are you able to transpose the data at source?

indranildatta · March 18, 2011 6:21AM

Thanks for your reply Steve. Is this something that we can see in near future?

Cheers!
Indranil.

tjbate · March 18, 2011 6:43AM

Indranil - the fastest way to do this is to use Excel copy paste, the clipboard paste menu has a transpose option. We wondered if there was any real business purpose in the total transpose... we will see how many others routinely need a total transpose.

chris · April 4, 2011 10:59AM

Hi,

We have added a Transpose operation in both Omniscope and DataManager. This will be available in tonight's Omniscope 2.6 release.

indranildatta · April 4, 2011 11:06AM

This is great news! Thanks a lot Chris. I will try it and leave feedback here.

indranildatta · April 5, 2011 6:49PM

Hi Chris,

I just tried this feature and it works great. Thanks a lot for getting this done so quickly. Cheers!

Welcome!

Categories

Ideas Parade

Tagged