Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Chained app

praneshsapmm
8 - Asteroid

Hello ,

 

Iam working on chained aap where values of posting date from and to entered in Analytic aap . 

 

But the aap is not recognising the value that was entered . 

 

Below is the workflow and command entered . Any help would be appreciated . 

 

praneshsapmm_1-1622641110307.png

 

 

 

 

praneshsapmm_0-1622640965980.png

 

4 REPLIES 4
Thableaus
17 - Castor
17 - Castor

Hi @praneshsapmm 

 

You need to update the "Expression" in the Action tool.


It seems you're updating the Mode - value= "Custom". Change that to the option below.

 

Also, don't forget to use "Replace a specific string" and point to the dates you're replacing.


Cheers,

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @praneshsapmm,

 

This will be because your action tools are not configured correctly, the aim of the action tool is to allow the interface tool (in your case a date tool) to understand which part of your main workflow you want to be updated.

 

In this example i'm going to use a standard filter tool with a custom filter, but the same will apply to your in-db version:

 

Filter tool configuration: I'm looking for dates between a start date "2021-06-02" and an end date "2021-08-04"

 

Jonathan-Sherman_0-1622643384421.png

 

I have two date interface tools, connected to the main workflow by two (automatically created) action tools:

 

Jonathan-Sherman_1-1622643450675.png

 

In order to define how these date interface tools interact and affect the filter tool we need to amend the action tool to highlight the Expression, and below tick "Replace a specific string" For the action tool of our first date (i.e. start date) we want to replace JUST 2021-06-02

 

For the second action tool we want to replace JUST 2021-08-04

 

Start Date Action Tool:

Jonathan-Sherman_2-1622643587621.png

 

End Date action tool:

Jonathan-Sherman_3-1622643722511.png

 

This will allow the interface tools to update the particular elements of the filter function we've selected.

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

 

 

praneshsapmm
8 - Asteroid

Hi @Jonathan-Sherman ,

 

This works . Thankyou very much .

 

Can you also let me know how to feed more than one value for list box condition mentioned below .

 

Thanks.

 

praneshsapmm_3-1622729097209.png

 

 

 

praneshsapmm_1-1622728858283.png

 

 

praneshsapmm_4-1622729242870.png

 

 

 

Thableaus
17 - Castor
17 - Castor

Hi @praneshsapmm 


See two examples attached.

 

If it's a string value, you need to put the values in between quotes. So you need to use this config

 

Thableaus_0-1622733688695.png

 

And replace what's inside the IN clause

Thableaus_1-1622733711778.png

 

If they are numeric values, then you need just use comma as a separator (,). And replace the values inside the IN clause the same way.

 

Thableaus_2-1622733762922.png

Thableaus_3-1622733776169.png

 

 

Cheers,

Labels