Mumbai, IN

Welcome to the Mumbai User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

SOLVED

Filter out result into a new field

Kuldeepmathur
7 - Meteor

Hi All,

 

I have 2 fields Count_EMP & Termination Status. My requirement is to populate

(Count_EMP where Termination Status is True)/ (Count_EMP where Termination Status is FALSE) into new separate field "Division"

 

COUNT_EMP      TERMINATION_STATUS
         39                                             False
         81                                             True

 

Thanks,

Kuldeep

4 REPLIES 4
rushabh_shah
8 - Asteroid

Try using the attached workflow.. Have used Filter and AppendFields node.

 

Regards,

Rushabh

 

 

Kuldeepmathur
7 - Meteor

Thanks Rushabh.

 

Could you please share your Input file mine is mentioned below.

 

COUNT_EMP      TERMINATION_STATUS
         39                                             False
         81                                             True

rushabh_shah
8 - Asteroid

I have created the input file based on the format u shared. Attaching the same.

Kuldeepmathur
7 - Meteor

Thanks for the quick revert, Rushabh..

 

Actually, in my scenario, I have several different fields as well I need to append them as well.

 

Thanks,

Kuldeep