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

[#1]

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?

[#2 · Accepted solution]

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'

)