Platform

 View Only

 Ability to perform a JOIN step on hidden columns

Jump to  Best Answer
  • TBMStudio
Apptio Community Member's profile image
Apptio Community Member posted 06/17/21 11:47 AM
When in excel, on data which has more than 2 key fields, we concatenate the 2 fields to form a "unique key" for each row, so that we can use this unique key to perform a lookup or a join with the other data set which should have a similar unique key.
In Apptio, the JOIN step doesn't work when I create and hide the unique key of my table.
Is there any solution/alternative to this?
#TBMStudio
Renee Daignault's profile image
Renee Daignault posted 06/17/21 02:41 PM  Best Answer
Hello Saaraunsh - Are you hiding the column in a hide and rename column step? You are unable to use a column after you hide the column in the transformation pipeline. Alternatively, you could create the join and then use a hide and rename step to hide the column you are referring to. I am unsure if the join has to be the last step. If it does, I would then create a transform for the output of the table and do a hide and rename there and use the transform for your final table. You would need to model/mapped column step in the transform table. 

Let me know if you have any more questions!
#TBMStudio
Apptio Community Member's profile image
Apptio Community Member posted 06/21/21 07:54 AM
@Renee Daignault The JOIN step becomes the last step by default. So, even if I try to add the Hide and Rename step after I perform my JOIN, Apptio ​pushes the Hide and Rename step ahead of the JOIN step.
As an alternative, I am creating a new table from my original table and performing my additional steps in the new table.
#TBMStudio

Related Content