- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to use lookup processor to compare NULL Value?
- Labels:
-
Apache NiFi
Created 01-16-2024 09:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have chain of look up processors.
Suppose I have a flowfile where the lookup key is a null value, and I intend to retrieve a corresponding value from a MySQL table. However, I consistently encounter an issue where the lookup process returns unmatched results, even when there are null values present in the MySQL table.
For instance, the 'filing_status_ID' field contains null values. When attempting to compare it with specific columns in the MySQL table, where the comparison value is also null, the outcome consistently registers as unmatched.
what can I do so that there will be match case? Like flowfile.key = mysqltable.key return match (NULL = NULL)
Created 01-18-2024 09:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can anyone help this?
Created 01-22-2024 07:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is the exactly problem I was facing, still no idea how it can be done.
