Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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?

 

1 ACCEPTED SOLUTION

avatar
Explorer

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 solution in original post

1 REPLY 1

avatar
Explorer

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'

)