Visual Query Builder Pull only records where field is numeric only

[cowannbell]

I need to pull records where fee code is only numeric numbers.

What would be the criteria using the Visual Query Builder?

Thank you.

[ShankerV]

Hi @cowannbell 

Do you have any sample data. 

Many thanks

Shanker V

[cowannbell]

b467

1234

1h4t

Etc.

[ShankerV]

Hi @cowannbell 

Please find the expected output.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[cowannbell]

I'm trying to do this in the Visual Query Builder before I bring the data in.

[ShankerV]

Hi @cowannbell 

Got it. Here it the solution.

I donot have a database connected now with current alteryx.

Hence pasting the Visual Query Builder SQL query. 

Please paste and run the workflow to get the desired numeric value alone to be input.

SELECT columnname FROM tablename WHERE ISNUMERIC(columnname) = 1

After pasting the query, do the test. If its successful, you can run the workflow.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V