Hello experts, could you please guide me on how to remove the records with a deletion flag in the next column? An example Excel file is attached for better understanding.
Hi, @akhukla
FYI.
Hey @akhukla, I agree with @flying008's idea. If the deletion flag comes from manual input rather than generated by the system, you may want to add some preprocessing before applying it. For example, adding a cleansing tool to clean any trailing spaces that people may enter in the cells and using a contains condition for filtering can help handle differences in letter casing.
