Cloud Pak for Data

 View Only
Expand all | Collapse all

Filtering data in Data Virtualization: can I filter specific table?

  • 1.  Filtering data in Data Virtualization: can I filter specific table?

    Posted Sun September 25, 2022 11:29 PM
    Hi, team

    I have a question for the Filtering data in data virtualization.
    I knew that we can enter some criteria to filter specific tables.

    For example, if there are four tables: 
    2022_aaa
    2022_bbb
    2021_aaa
    2021_ccc

    I knew that I can filter with the words: "2022", to perfectly select 2022_aaa、2022_bbb
    But I would like to ask, can I enter "2022_aaa, 2021_ccc" to select only these two table?

    Thanks.

    Best,
    Timas

    ------------------------------
    Yu Hao Tung
    ------------------------------

    #CloudPakforDataGroup


  • 2.  RE: Filtering data in Data Virtualization: can I filter specific table?

    Posted Thu September 29, 2022 01:53 PM

    Hi Yu,

    The answer depends on where you are filtering :-) If you are filtering the tables to load and virtualize on the Data sources page, you can use the overflow menu on most data sources to filter data using wildcard character much like a regular expression.  Then, when you virtualize data, only assets that meet the filter criteria are displayed, which speeds up loading of tables. For more information, see Filtering data in Data Virtualization.

    Hope this helps,

    Trish



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