Need to know is there any way to append New data to existing dataset? Currently when a scenario comes to include New line items to existing dataset, we need to download the file from Apptio, include the New line items to the file and upload it back into Apptio.

The Append feature was available in R11 version but in R12 it's not there it seems. Please advise on this. Thanks.

Hi Pinaki,

Currently there's no way in R12 to append data to an existing data set. We intend to close this gap, so it's in the works.

However, if you have Datalink, you do have the ability to append data through it. 

Thanks,

Guy

Thank you Guy for clarifying on this. Thank you.

I could use this feature. OR some why to remove time period dimension (reverse date partition so it becomes a single table). If there is a way, let me know plz. 

Hi Zakria,

What specifically are you trying to do? Are you trying to set up a table that would apply to all time periods? In that case, I'm not sure how the ability to append data would help.

I guess I don't fully understand what you mean by "..so it becomes a single table".

Thanks,

Guy

I want to run Lookups between months. E.g. does a server present in previous month exist in this month. So compare between two months and determine adds, removals, and changes - quantity and cost. Then know what those changes are. In order to do that I was thinking if there is a single table with all the time periods included, I can create keys, manipulate time periods, and use lookups on the table itself to determine above mentioned changes. Hope what I am typing makes sense. 

Hi Zakria,

Ok, I better understand your use case now. There are other fairly simple ways you can do it today, without using any sort of "append" functionality. Here are a couple that come to mind:

1. Based on your monthly data, you can create a metrics, e.g. "Server Count", and assign "1" to every server (you can also create metrics like "Server Cost" and "Server Quantity" and assign the relevant values there). Then, on the reporting layer, you can create reports that do month-over-month comparisons based on those metrics. I don't know what other comparisons you want to do, but it should work for the examples you provided.

2. Lets say your original table is called "Servers". You can create another table and call it something like "Servers - Prior Month".
Then when you load, e.g., the July file into the "Servers" table, you'll also load the same exact file into the August "Servers - Prior Month" table.
Then, come August, you'll load the August file into the August "Servers" table.
You can now do a lookup on whatever comparison/validation/information you need between the two, and you essentially have a comparison between current month and prior month.

Let me know if any of these will work for you, or if your use case is different then my understanding.

Thanks,
Guy

I also wish the Append data to existing tables was available.  We have similar tables from different source files (same headers) that worked easily in R11 when appending one to the other as part of the upload process.  To get around this in R12, I take both Excel files and copy the data from one to the other.  Not a big deal, but would eliminate that step if I could just append one to the other as part of the upload process (different than appending existing tables).  I assume will be in a future release!

Hi Guy,

Just checking by when the Append feature implementation is expected in R12.

Thank you.

Hi Pinaki,

This is still being worked on, but there is no expected release or date for this feature to be available yet.

Thanks,

Guy

Any ETA on Append?