question Re: Deleting Specific fields data based on another field Data in the file in NIFI in Support Questions

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

NIFI_123 — Wed, 18 Aug 2021 20:10:32 GMT

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?

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

NIFI_123 — Mon, 23 Aug 2021 14:22:20 GMT

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'

)