Filtering only figures from the data

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

Filter only number.xlsx

Common Use Cases

Accepted answers

Qiu

@SH_94
Here is another one.

0405-Jcsh_66.yxmd

All comments

Luke_C

Hi @SH_94

Here's two potential solutions:

Use the tonumber function in the filter tool. Only successfully converted records return in the true anchor
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!

New Workflow2.yxmd

Qiu

@SH_94
Here is another one.

0405-Jcsh_66.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703