4

Column Headers

Option to select the first row of data as column headers. Currently you can use the SLICE function to deal with column headers but this solution is not ideal when working with complex formulas.

10 comments

  • 1
    Avatar
    Luca Giuranna
    I second this.
  • 1
    Avatar
    Stefan stefan

    I totally agree. If a table has the header in the first row this info can be saved together with the Data Source. If the Data Source knows that its first column is the header, then no klip has to deal with SLICE over and over again. Those SLICEs make formulas grow more quickly and even worse, if you forget it in just one place, results are strangely off and the error is not easy to spot.

  • 1
    Avatar
    Scott Lawrence

    Thanks for your input. We really appreciate the additional context and use cases.

    We are investigating a feature that may help here.

    Cheers,

    Scott.

  • 0
    Avatar
    Brian Staats

    Any update to this feature?

  • 0
    Avatar
    Paulo Carvalho

    Are there any updates on this feature?

  • 0
    Avatar
    Carlos Kynäslahti

    I was editing my Table and clicked the "?" icon next to the "Use custom header" and found this:

     

    However I can't actually find this setting anywhere in the Klip editor. 

     

    Anyone have an idea how to enable this?

     

  • 2
    Avatar
    Carlos Kynäslahti

    I found how to enable it. Make sure you choose the top level "Table" component from the browser:

  • 1
    Avatar
    Nikta Kanuka

    Glad you found it, Carlos!

    And thanks a ton for posting it back here to help others out too :). 

    I'll just add one more thing: this checkbox only shows up if you have data in your Klip (otherwise, you won't see it). We can definitely improve the discoverability of this feature, so I'll make a note for the rest of the product team for the next time they are looking at this issue!

  • 0
    Avatar
    Tim Meredith

    That solution is nice for when a table is pulling from only one data source. But when a table relies on complex queries that use multiple data sources, all with header columns, it doesn't help at all and the slice() calls proliferate something awful.

  • 0
    Avatar
    Carlos Kynäslahti

    @Tim

    I just gave up and named everything manually. The whole SLICE() thing gives me the creeps, it's easier to just manually name columns instead of worrying you forgot to use the function and your data would be messed up.

Please sign in to leave a comment.