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.
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?