Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Alteryx Analytical App passing '_' when encountering empty spaces for column values

Highlighted

Team,

Kindly help me out here. I have been trying to solve for this app problem. 

My requirement is to show users a list box of customer names they want the data output for. The dates and level of granularity work fine but when it comes to List box passing the parameters to Filter tool it uses an underscore '_' instead of the wide or empty space in the column name and this is causing my filter tool to miss out on most of the values. 

For instance, BDI LOGISTICS LLC  is BDI_LOGISTICS_LLC and the data stream does not recognize this new input from the list box tool interface. 

Can anyone help me on this? 

Highlighted
Bolide

Could you post your workflow please. 

Highlighted

Drew, I just did. Apologies for missing out on this earlier. 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

You can replace those underscore characters with spaces by setting your Action (27) tool to "Update Value with Formula" and using the following expression:

 

'[CUSTOMER_NAME] IN ('+RegEx_Replace([#1],"_"," ")+')'

 

This will build the same IN expression using the user-input values and replaces "_" with " ".

Highlighted
Alteryx
Alteryx

Within the filter tool, use a replace formula to replace the "_" with a space (" "). See attached for an example. 

 

echuong1_0-1582058567002.png

 

Labels