Cloud Pak for Data

 View Only
  • 1.  Filter multiple conditions on data virtualization sources

    Posted 26 days ago

    Hi, Teams,

     

    Our customers need to filter multiple conditions on data virtualization sources.

    But we tried a wildcard approach like {a, b} is not working.

    Can we filter multiple conditions in the same field (like a table)? I didn't see any of this information on the documents, thanks!

     

    Document links: https://www.ibm.com/docs/en/cloud-paks/cp-data/4.0?topic=sources-filtering-data



    ------------------------------
    Chun Hsiang Wu
    ------------------------------


  • 2.  RE: Filter multiple conditions on data virtualization sources

    Posted 26 days ago
    Edited by Trish Smith 26 days ago

    Hi Chun,

    No, you cannot filter multiple conditions at the same time currently.

    You can use the % or _ fields to find schemas or filter tables based on a single condition. You can use %ab% to denote wildcard + ab + wildcard.  However, you can't specify "a" or "b".



    ------------------------------
    [Trish] [Smith] [MBA, BMath, Mom]
    [Content Developer]
    [IBM]
    [Ottawa] [ON]
    [613-356-5435]
    ------------------------------



  • 3.  RE: Filter multiple conditions on data virtualization sources

    Posted 23 days ago

    Hi Trish,

    Thanks for your reply!
    Do you have any suggestions if our customer wants to filter data sources to improve loading efficacy but has a different table name rule?

    Best regards,
    Sean



    ------------------------------
    Chun Hsiang Wu
    ------------------------------



  • 4.  RE: Filter multiple conditions on data virtualization sources

    Posted 21 days ago
    Edited by Trish Smith 20 days ago

    The only suggestion I have is to upgrade to CPD 4.5 where there is a new view, the Explore view, where you can browse through databases, schemas, and available tables in a connected data source.  In the Explore view, you cannot search for tables, but you can drill down to find tables quicker.

    For now, you can filter by:

    • Using wildcard characters if possible - This works only for desired sets of schemas or tables that have one or more substrings in common that also adequately exclude other unwanted results. This is a single condition.
    • Updating the filter for all groups of tables you want to browse for virtualization. This is also only a single condition.


      ------------------------------
      [Trish] [Smith] [MBA, BMath, Mom]
      [Content Developer]
      [IBM]
      [Ottawa] [ON]
      [613-356-5435]
      ------------------------------