Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only

  • 1.  Lookups Using Flatten Hierarchy Values

    Posted 07/26/18 02:22 PM
      |   view attached

    Hi Everyone,

     

    Receiving an interesting error when attempting to lookup a value generated by a Flatten Hierarchy step. Formulas currently don't work and I have no idea how to consolidate these two data types. See screenshot.

     

    "Mismatched lookup from type "LABEL" ("BoxedStringOffset") to type "LABEL" ("String")".

     

    Flatten Hierarchy is basically useless at this point. 







    #TBMStudio


  • 2.  Re: Lookups Using Flatten Hierarchy Values
    Best Answer

    Posted 07/26/18 02:29 PM

    Solved my own problem.

     

    Created a new level_1 column as newLevel1 = ""&Level_1

    This turns Level_1 into a regular string, using that in my lookups instead. 


    #TBMStudio


  • 3.  Re: Lookups Using Flatten Hierarchy Values

    Posted 11/16/18 09:38 AM

    Very helpful.  Thanks


    #TBMStudio


  • 4.  Re: Lookups Using Flatten Hierarchy Values

    Posted 07/30/18 07:01 AM

    Sorry I couldn't help on this one but thank you for coming back with the solution


    #TBMStudio


  • 5.  Re: Lookups Using Flatten Hierarchy Values

    Posted 01/21/20 10:55 AM

    @Matthew Poletiek - This was super helpful!  Thanks 


    #TBMStudio