Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
  • 1.  TableMatch exception

    Posted 11/13/18 07:27 AM

    Is it possible to have a logic usingTableMatch where it finds the line, where the word 'folder' exists in a text string, but not if the string contains ‘department folder’.

     

    Would like to keep this in a TableMatch, because I have more conditions I'm and rules I'm applying. So the main question is whether I can create conditions. Would like if I could keep such logic in a TableMatch rules table rather building additional columns.

     

     

     




    #TBMStudio


  • 2.  Re: TableMatch exception
    Best Answer

    Posted 11/14/18 01:31 PM

    Hi @Jesper Kisby, this is totally possible! If you take a look at the TableMatch function page (https://tbmcouncil.jiveon.com/docs/DOC-5073#jive_content_id_Rules_table_values_supported) you can see the "!" operator will cause a match only when whatever string you specify is NOT included. So your rules would have a column with "folder" and then another column with "! department folder", which is saying If the entry has folder and does NOT have department folder, return match.


    #TBMStudio


  • 3.  Re: TableMatch exception

    Posted 11/14/18 01:36 PM

    So I would have two columns in my TableMatch logic referencing the same column containing the text string?


    #TBMStudio


  • 4.  Re: TableMatch exception

    Posted 11/14/18 03:40 PM

    That's correct. Each column in your rules table reads as an "AND" statement and all rules columns are evaluated against the match column.

     

    This rules table would read If [match column] Is Folder AND Is Not Department Folder, Return Value.

    Is FolderIs Not Department FolderReturn Value
    folder!department folderYes

    #TBMStudio