Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
8 - Asteroid

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
8 - Asteroid

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
8 - Asteroid

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