Filtering only figures from the data

[SH_94]

Hi Community,

I have data as per screenshot below which consist of other informations , ie : spacing, empty column ,wording and etc and figures. However, i only want to the alteryx to filter and produce figures. May i know how can we edit in the Alteryx?

Thank you in advance

[Luke_C]

Hi @SH_94 

Here's two potential solutions:

1. Use the tonumber function in the filter tool. Only successfully converted records return in the true anchor
2. Use regex match in the filter tool to check for records that only contain numbers. I used an 'or' clause here to account for the negative numbers, but I'm sure there's someone more experienced in regex that potentially has a quicker way.

Hope this helps!

[Qiu · Accepted solution]

@SH_94 
Here is another one.

[SH_94]

Hi @Qiu ,

Thanks a lot for the prompt response.

Could you briefly explain on the symbol and concept used in this case? I had tried the formula and it does not filter out the " null " column in the workflow.

Thank you so much for your help.

[Qiu]

@SH_94 

Hope this would be alright.

[SH_94]

Hi @Qiu,

I have tried to use the formula and noted that it does not filter out the " null " column in the workflow. May i know how can i edit the formula to capture this part?

Thanks a lot again for your time.

[Qiu]

@SH_94 

Sorry about that. Did not expect null rows.

Lets change the last identifier from * to +.

[Qiu]

@SH_94 

Appreciate you would mark the reply as accept, if you find it useful. 😁