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.
Solved! Go to Solution.
You have to make sure to select the value you want to update - in this case the "AAA"
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!
I don't really understand. I've selected the value I want to update and it still doesn't work.
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)
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.
It's an analytic app so I'm using the wand.
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_Spill 's point though, you probably need to look at the logic to make sure it's going to do what you want to do
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.
@KateC try the attached workflow