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

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

Capture2.PNG

Input

Apps

Accepted answers

markcurry

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

All comments

Raj

@luised4

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

luised4

Sure. Please see attached.

Capture4.PNG

Capture5.PNG

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

See here : Debugging Alteryx Analytic Apps – Alter Tricks

luised4

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703