I'm currently trying to append a rather large transform to a master data set but when I do the row count goes to "0" on both the Master Data and the original transform.

Any ideas as to why this is happening and what I can do to resolve the issue?

Hi Julie, I moved this over to the Cost Transparency forum where more of our experts will see it. I'll check back to make sure it gets a response. 

Hi Julie,

Whenever that happens it usually means there is a circular reference between those datasets. I know this is one of many reasons I am sure but it has happened to me twice and both times it was a circular reference. What this means is that either these data sets are looking up into each other, both datasets are looking up into the same different dataset and pulling back the same info or one is a transform of the other, etc. In this case since it is a master dataset I am assuming is would be the first reason or second reason. 

Is this an OOTB Master dataset and do you think this could be the reason?

Let me know how I could help further,

Lauren Griessel

Hey @Julie Batty,

I expect @Lauren Griessel is absolutely right. Try removing the most recent table appended to your master table. If the master table lights up with rows again, try looking at the formulas within your other table (recently detached) to trace down the issue. Then, determine what actions can be done to bring your desired data into the master table.

Thanks Lauren, a circular reference was indeed the cause of the 0 lines. I was trying to append a new Vendors file to the Vendors Master Data, however the transform I was using was indeed looking up a reference from Vendors Master Data.

Always learning with Apptio :-)

Thanks for your help Lauren

So glad we could help! Please keep on asking questions as we learn from them to.