How to filter specific file in Alteryx

Question

Hi all,

I am new to Alteryx, i want to know how to filter a specific file e.g. (Admin*) in Alteryx, i only want to see all file start with Admin only. I attached a sample Excel file for your reference. Hope some one can guide me. Thank you.

Regards

Douglas

I want to search file in Alteryx.docx

cmcclellan · Accepted Answer

Use this ...

LEFT([SamAccountName],5) = "Admin"

LEFT means you take the first (ie left) 5 characters, if it is anywhere within the string you should use CONTAINS instead.