Skip to main content
To homepage To homepage
SUBMITTED

Row filtering - add support for empty and non-empty values

  • December 21, 2023
  • 2 replies
  • 31 views
K
Contributor
Forum|alt.badge.img+2

Is it possible to only load records from a table in which a date column is empty from an ODX SQL data source (loaded in with ADF)? Using filter rows, I cannot find an option to do this:

 

When I use the operator ‘Equals’ and fill in NULL as value, I get an error on executing the transfer. By the way, we are on 20.10.40!

2 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@KajEmergo Filtering out empty values (i.e. IS NULL) or non-empty values (i.e. IS NOT NULL) is currently not supported using Row Filtering in an ODX data source. A potential workaround could be to change to a TimeXtender SQL data source (rather than ADF) as this data source supports query tables, which can be used for this type of filtering. Query tables are not supported for ADF data sources at this point in time.

 

I will convert this to a product idea. 

    K
    Contributor
    Forum|alt.badge.img+2
    • KajEmergo
    • Author
    • Contributor
    • December 28, 2023

    @Christian Hauggaard thanks for your reply and coverting my post into an idea. Would be great to see this option available in the future.

    Terms and ConditionsAccessibility statement