Check last folder name using filter tool

Question

I get multiple file paths from different directory tools now I have to segregate based on the folder name

FilePathC:\program\ABC\lmnop.xlsxC:\program\mnop.xlsxC:\program\ABC.xlsx

Check if the last folder is ABC or not (using a filter tool),if yes it should come in true anchor or else it should be in false

binu_acs · Answer

@Sshasnk you can use the regex replace function to check whether the folder name is ABC or not in the filter tool

Filter_0929.yxmd

DataNath · Answer

@Sshasnk I provided a solution to this yesterday. Let me know if there’s a reason this doesn’t work and can revisit if needed: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Check-if-the-folder-name-is-present-or-not/m-p/1007741