Filter out result into a new field

[Kuldeepmathur]

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

[rushabh_shah · Accepted solution]

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

Regards,

Rushabh

[Kuldeepmathur · Accepted solution]

Thanks Rushabh.

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

COUNT_EMP      TERMINATION_STATUS
         39                                             False
         81                                             True

[rushabh_shah · Accepted solution]

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

[Kuldeepmathur]

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