Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

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

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

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'

)

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.