Mapping Question - create node if condition met

Im reading in a .csv file into a fcc. Im doing the mapping and i want to not create a new line if a condition is met.

1.png

I've go the below data to be mapped, but i only want to create a newhireline node if the department does not = C004

The issue is the C004 is embeded at the end of a string.

I've tried using Endswith and other if statements but i cant quite get it to ignore records with C004 and include all those that do not equal C004.

What would be the best way to approach this?

THanks