IBM Apptio

 View Only

 Are there character limits to ID fields?

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Jamie Chaffin's profile image
Jamie Chaffin posted 04/21/22 10:44 AM
I am working within our AWS cloud data and trying to use the Row ID field in lookups to bring in additional data, but it is returning various unexpectedly. When I looked up one of the Row IDs in the source table (I filtered by value to copy exactly), it keeps data in the view that doesn't match the Row ID which I think has something to do with why I am seeing various returned on the lookups. Are there any character limits on fields or has anyone else run into this issue?

*I had filtered on the first row value below and got results that did not match.
#CostingStandard(CT-Foundation)
Attachment  View in library
AWS RowID Issue.PNG 24 KB
Rene Norskov's profile image
Rene Norskov posted 05/06/22 07:07 PM  Best Answer
This is because two pipe characters - || - is an OR operator in the auto filter.  It enables you to search for multiple strings, e.g. Network||Delivery will return rows that has either Network or Delivery strings.  You won't be able to search for your strings in the UI.  Perhaps use a different delimiter while you troubleshoot.
#CostingStandard(CT-Foundation)
Jenny Franklin's profile image
Jenny Franklin posted 04/21/22 10:56 AM
Apptio Community Member updated 04/21/22 10:59 AM

That's weird - should only return items that contain what's in your filter/search - and clearly it's not.  Have you tried creating a different type of unique lookup - like creating a new column by concatenating several other columns and testing using that?
#CostingStandard(CT-Foundation)

Related Content