Merged Columns in Excel – How can I get rid of them?

This topic contains 1 reply, has 1 voice, and was last updated by  Frank 7 months, 1 week ago.

  • Author
    Posts
  • #509
     Frank 
    Keymaster
    • Topics Started - 50
    • Replies Written - 45

    When exporting to excel from a Stratum view it seems that sometimes there are merged columns for some of the data. This makes it difficult to use the data in those columns. How can I get rid of this?

  • #510
     Frank 
    Keymaster
    • Topics Started - 50
    • Replies Written - 45

    This question came up in our open question Insight session a couple of weeks ago. The solution is to remove any conditional formatting you have in the view. When a measure has conditional formatting on it Stratum creates a set of merged excel columns so that the formatting can be included. If you remove the conditional format this will not happen, making the data in the column easier to use in excel.

    Also – coming up in the next release – 6.9 – if you have a license to the Stratum Broadcast Server you will have multiple options for exporting to excel. One will be the same export available today – which is called an Excel Report. The new format is called Excel Data which will be exported with all the formatting removed, the values repeated on each row and no totals. By doing this Stratum is able to export large data sets much faster. The idea behind this new feature is to allow for exports that are made for information delivery, which are the Excel Reports that you can export today. The new Excel Data export allows for exporting data to be used as data in a pivot or other situation where a large amount of raw data is required. Other examples would be for exports to Power BI or to a table in excel.

You must be logged in to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

©2019 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials

or    

Forgot your details?