Analytic App - Action Tool won't update my Text Input tool

My List Box is set up to select a reporting group, and I've manually listed the four different groups. My Action Tool is set to Update Value (Default), and is connected to a Text Input tool with a column called GroupSelected and a dummy entry in the first data field. I then want to Union the Text Input to my data, which is coming in through a different string of tools, then Filter based on GroupSelected=Group. I've got this set-up from another workflow where this actually works, so I must be missing something.

I'm running as an Analytic App, selecting a group that I know has data in my input file, and I'm getting no results.

I've got this set-up from another workflow where this actually works, so I must be missing something. Sample attached.

Sample Workflow.yxwz

Interface Tools

Accepted answers

apathetichell

@KateC - key question. Are you trying to support multiple selections - or only one? You have this set up for a list box. A list box supports multiple selections. If you want a single selection - use a dropdown. Here is the mutli-select version. Swap your list box for a dropdown if you want to limit this to a single selection.

corrected sample for multi-selection.yxwz

All comments

alexnajm

You have to make sure to select the value you want to update - in this case the "AAA"

Analytic App - Action Tool won't update my Text Input tool.png

alexnajm

However, you might have to look at your List Box tool to see how you want those values to go through into your Text Box. Good luck!

KateC

I don't really understand. I've selected the value I want to update and it still doesn't work.

alexnajm

How are you running the workflow? Hitting the run? If so, make sure to hit the wand icon to run it as an app. I would also suggest using the Debug feature in Interface Designer so you can see how the value passes into the Text Input! Debug Workflow (alteryx.com)

Bren_Spill2

Hi @KateC

You'll need to append the data, not union it, so the filter tool works correctly.

The issue with the input setup is that it's placing all the values into that one cell, and also is evaluating whether or not the group has been selected - see screen shot below. I added some parse tools so the data appends correctly. Not sure if it's the most efficient solution but it works.

Debug view.PNG

Sample Workflow (1).yxwz

KateC

It's an analytic app so I'm using the wand.

alexnajm

Then it's working for me (working meaning it updates the Text Input) as soon as I make the change I outlined above! To my and @Bren_Spill2 's point though, you probably need to look at the logic to make sure it's going to do what you want to do

KateC

I've tried Brendan's solution too and while it works in the sample workflow I'm still getting no results from my real data (which contains data for the group I'm selecting), so it's something in the workflow that doesn't work. I have no idea what else to look for. It should be straightforwardly appending the group I select in my List Box to my data. I still think my test box isn't being updated with my selection.

binu_acs

@KateC try the attached workflow

Sample Workflow (1).yxwz

Bren_Spill2

If you haven't already, try the debugging that @alexnajm mentioned. That will show you where the logic is breaking.

(Unless @binu_acs solution is working for you!)

KateC

Closer, @binu_acs - I'm getting output now but not the correct output. I'm selecting for FNMA, the "default" in my text file is GNMA, and so I'm getting a blank file because GNMA has no data in the input file (that's why I'm trying to select FNMA). The Action tool is not updating my text file.

apathetichell

corrected sample for multi-selection.yxwz

KateC

Thanks @apathetichell - I took your advice and swapped by list box for a dropdown and now it works. Thanks everybody for all the suggestions!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235