In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

error sqlexecute: numeric valuei is not regonized

Cferrer6
8 - Asteroid

hello, 

 

i have my flow connected to snowflake. i create a column to give me the month and year(yyy-mm) from an existing field that had yyy-mm-dd format . i then tired to filter out a specific month (example 2023-05) but it gives be this error (using in database tools)

 

any ideas why its throwing that error?

1 REPLY 1
Amy_smart
11 - Bolide

Hi,

 

You could use a filter and then choose [date]does not contain '05' month.

 

Numeric values usually do not have 0's before the numbers.

 

Thanks,

Amy

Labels
Top Solution Authors