Platform

Platform

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

 View Only
Back to discussions
Expand all | Collapse all

Using Primary Key concatenation with enriched editable tables

  • 1.  Using Primary Key concatenation with enriched editable tables

    Posted Wed August 14, 2024 01:18 PM
    Edited by Ed Hayman Tue November 05, 2024 05:54 PM

    A primary key is often used in transform tables that is the concatenation of several columns.

    • For example: Primary Key = Cost Center & " - " & Account Code & " - " Project Code (etc.)

    If there is no value in a row for the Project Code, then the primary key will include a trailing space

    • Transform table example: "CC-123 - ACCT-10020 - "

    Issue:

    When the transform table is used by an enriched editable table, the MySQL database will automatically TRIM any trailing spaces. As such, changes made in the enriched editable table will not align with the actual rows in the transform table since the primary keys won't match.

    • Enriched editable table example: "CC-123 - ACCT-10020 -"

    Recommended Configuration: When using concatentation to create a primary key in a transform that will be used with an enriched editable table, do not use a space as part of the concatenation for the last column. This applies to both the concatenation formula in the transform table; and any script formula in the "Primary Key" column that is required to add a row to the enriched editable table.

    NOTE:  This recommendation will be added to the help documentation.  


    #TBMStudio