Trying to add a data filter on a string field and would like to use Intersects Table:Column

I Tried Table Name:Column Name but did not work, as well as a series of other combinations

Online Help just says that Intersects Table:Column filter Operator can only be used for String Datatypes which I did confirm.

Online Help should really be expanded to give more examples of each type of data filters. I notice this throughout the online help.  Apptio syntax is simple compared to other programming languages but the online help needs enhanced to allow for mastery skill level.

Operators and data types with filters

Some row filter operators only work with certain data types. For example, Less Than works only with columns that contain numeric data, while Equals works with columns containing any data type. The following table describes the data types that work with each row filter operator. The top group of operators in the table provides functionality similar to wildcards. Filters do not support traditional wildcard symbols such as *.

Hi Kevin,

This feature should be working for you - I just tried it on a sample project.

By any chance does the lookup column name have punctuation within it?

I notice that the usual curly brace method (e.g. {Table Name.Column Name} doesn't work here in the data filter popup dialog.

If this is the case, you could try creating a new column in the lookup table whose value formula is equal to the original column (but ensure the new column has no punctuation in its name).

- Chris D.

So as you can see I have a table called PC Accounts, with values in an Account field type Label or String

Then in my Data Set I am trying to create I have a filter where ACCOUNT (from raw data file) intersects with PC Accounts:ACCOUNT.  This filter should produce results but does not.

Your configurations look correct in your screenshots.

You may want to consider contacting Apptio's support team if you haven't yet about this issue.

Chris, Thanks taking a look at this.  Not sure if posting questions like mine is the intent of this portal or not.  It may be helpful though if the support team took the top 10 support questions they receive each month and post solutions on the portal, and really build a repository for self help. I for one like to dig in until I get to a resolution and logging issues with support and waiting for reply really disrupts momentum.     

Thanks again

-Kevin

Questions like yours are good opportunities for others to perhaps jump in with a suggestion - or you might wind up helping them solve a similar issue. I'm passing along your Top 10 idea to our support team director, and thank you for the feedback.

@Maha Ramachandran and I took a closer look - she found what was causing your Intersect filter issue.

Apptio has an order of operations, and the data filter was being applied before the transform table was switching the column type from numeric (as it appears in your original data table) to label (as it appears in your transform data table).

By switching the column type from numeric to label back in your original data table, the data filter works as expected.