How to filter specific file in Alteryx

[DouglasEKL]

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 

[cmcclellan · Accepted solution]

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.

[DouglasEKL]

It indeed helps, thank you very much.