Skip to main content
NIFI_123
NIFI_123
Gold ⭐️
August 18, 2021
Solved

Deleting Specific fields data based on another field Data in the file in NIFI

Hi Team,

 

I have a scenario if an Participant status  Filed value is 'Inactive' then i should update some of the columns data in the file with NULL/empty. Could you please help me in how can we achieve this?

 

NIFI_123
NIFI_123Answer
Gold ⭐️
August 23, 2021

Got this Scenario successfully  using Query Record Processor.

Written SQL query with UNION ALL

(

Select

col1, col2, .....

From tb1

where 'participant status' <> 'inactive'

 

UNION ALL

 

Select

col1, col2,

..

'',

'',

'',

''

FROM tb1

where 'participant status' = 'inactive'

)

View in thread

1 reply

NIFI_123
NIFI_123AuthorAnswer
Gold ⭐️
August 23, 2021

Got this Scenario successfully  using Query Record Processor.

Written SQL query with UNION ALL

(

Select

col1, col2, .....

From tb1

where 'participant status' <> 'inactive'

 

UNION ALL

 

Select

col1, col2,

..

'',

'',

'',

''

FROM tb1

where 'participant status' = 'inactive'

)

Translate
Terms & ConditionsAccessibility statement