Why my workflow works but my app does not work?. I'm using Dynamic Input.

[luised4]

I'm using a Multifielf formula to covert the date  to String and I'm using a formula to take off the "-".  When I run in the workflow, it works, but when I run in my app does not work. I get the following error:

AlteryxSelect (122): No valid fields were selected.
DynamicInput (35): Error SQLPrepare: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 26:
...switch_date_int BETWEEN and AND
^
Encountered: AND
Expected: CASE, CAST, DATE, DEFAULT, EXISTS, FALSE, GROUPING, IF, INTERVAL, LEFT, NOT, NULL, REPLACE, RIGHT, TRUNCATE, TRUE, UNNEST, IDENTIFIER

CAUSED BY: Exception: Syntax error

AlteryxSelect (130): No valid fields were selected.

Please advice. 

Thanks,

Luis

[Raj]

@luised4 

Will you be able to share the snip of configuration of action tools

[luised4]

Sure. Please see attached.

[luised4]

I'm using the same action tool for  my old version workflow. It started happening when I added the Date To string. My old version works. 

[markcurry · Accepted solution]

Hi @luised4 , in Interface Designer in the 2nd tab (Test View), you can populate the fields in your app and click 'Open Debug' this will create a separate workflow the same as the app running, this should hopefully make it easy to spot and fix where the issue is.

See here : Debugging Alteryx Analytic Apps – Alter Tricks

[luised4]

@markcurry  I already did it and it's pointing to my date. 

AlteryxSelect (122): No valid fields were selected.
DynamicInput (35): Error SQLPrepare: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 26:
...switch_date_int BETWEEN and AND
^
Encountered: AND
Expected: CASE, CAST, DATE, DEFAULT, EXISTS, FALSE, GROUPING, IF, INTERVAL, LEFT, NOT, NULL, REPLACE, RIGHT, TRUNCATE, TRUE, UNNEST, IDENTIFIER

[apathetichell]

what's your configuration of your multi-field formula tool? I don't think you need to convert this to text (it should already be text) - and if you have this trying to convert a fieldtype which isn't the correct field type in standard alteryx you'd hit an error. In AMP it does... different things.

I'd recommend getting a browse tool to capture the full query you are adding to your dynamic input so you can spot check what you are generating when you update these fields dynamically.

[luised4]

Hello guys. I was able to fix it in debug mode. Everythig was corrected. I was entering the StarDate like EndDate. I switch the fields in interfacedesign view. Now It's working because I'm entering the date fields correctly. Thank you for all your help.