% vs *

[nico101rsa]

Hi, new to Alteryx.

I have noticed that to indicate all you need to use a % 

Example: return all strings starting with Z will be Z%.

I am used to other queries always using * rather than %.

Am I correct in saying that in Ateryx the % means all?

[grazitti_sapna]

Hi @nico101rsa, in case you want to find all the words that start with Z all you need to do is use the StartsWith function. Please take a look at the screenshot.

You can use the filter tool and write the function StartsWith([Field1], "Z") to filter out all the values starting with Z.

In case this is not what you are looking for can you please send a sample dataset with the required output so that we can help you?

I hope this helps!

Thanks!

[flying008]

Hi,@nico101rsa 

You said use % in formula or query of Alteryx? as i know, the wildcard is * and ? in Alteryx syntax.

[nico101rsa]

My question was more to do with Syntax.  In below AM* did not work and I had to use AM%

(Brining back records that starts with AM)

So is Alteryx using % for wildcards?