I noticed a gap in our Vendor Data in the most recently updated June data. Information is loaded into the Vendors Raw Data, but the Vendors Transform has a Row Count of 0. 

What would cause the Transform to malfunction and fail to populate, skewing the Master Data set? 

Thanks!

Do you have any filters on the transform file?  

I added a data filter to the transform, and believe I successfully filtered the Unique Value. 

Thank You!

Generally speaking, not a good idea to filter by Unique Values/IDs. Over time you may find your data filter's definition is quite large referencing a lot of unique values.

I recommend adding a Filter Flag column and add logic to its Value Override to set it to "Yes" or "No". In this way, you can control elements filtered out via the Data Filter settings within the transform itself and more easily and clearly troubleshoot any rows that should or should not be filtered out.

If you find you're writing a long IF statement to accommodate all the unique values and/or other conditions, try incorporating the TableMatch function.

Agreed.  I was originally asking if any filters were in place because of the 0 row count they were now seeing.  I've had that happen when data ups and disappears and then I see I had a filter on it the whole time ha.  #FacePalm #DOH!

Are you using the ".pk" function in your unique ID? Occasionally this has to be reset by support.

Very good to know!

Tony- I am new to Apptio and am trying to learn what all of the different functions are and what they are doing.  Would you be able to explain what the ".pk" function is or where I can find more information on it? 

It's like a counter that can be used to help generate unique IDs in a dataset. There's a help topic where it's mentioned called "Generating unique IDs for table rows," but it doesn't really go into it as a function.

Thank you, Tony!

If new to Apptio, definitely use the search function on this site - awesome resource - it's like Google for Apptio   Definitely post questions, too, lots of questions - no question is too small! 

Ran into this one related to .pk recently... Tip: Resolving data validation differences with .PK column name 

Thank you, Jenny!  And thanks for the link to the other post!