List box challenges

[MCDR929]

Hello,

I'm building a chained app (the attached mock-up is step 2, where the breakdown is occurring).

When I run as an analytic app in the designer, my list box consists of column headers.  I need it to be the user IDs.  

I tried transposing it, but that doesn't seem to work for what I need the end result to be.

I THINK the action tool and the filter are set up correctly, but since the available fields aren't options, the filter doesn't yield any positive results.

Thanks in advance!

[danilang · Accepted solution]

Hi @MCDR929 

Since you already have a chained app, you're half way there.  Just get the first app to write out an .yxdb file that the second one reads from.  The .yxdb needs to be in a specific format with a series of unique name value pairs.

Then change the config of your list box to read the values from there

See attached

Dan

[MCDR929]

Thanks for the response, Dan.  I wasn't able to open your workflow; looks like you have a newer version than I do (I'll check to see if my company has made the update available).

I have my actual workflow set up to feed off a temp file from the first step in the chain.  However, when I try to run this as an analytic app, I get this error message when moving from step 1 to step 2:

So maybe that's where my issue is.  

I'm working off apps my boss made a while back, so maybe I'm creating the temp file incorrectly?

I have the data output in step one set to: %temp%..\Scarlet DC.yxdb

Then, the input in step two is: %temp%..\Scarlet DC.yxdb

Thoughts? Thank you again.

[danilang]

Hi @MCDR929 

The workflow is just an xml file.  If you open it with notepad you should be able to change the version(2nd line) to match yours

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">
  <Nodes>
    <Node ToolID="1">
      <GuiSettings Plugin="AlteryxGuiToolkit.Questions.Tab.Tab">
        <Position x="0" y="0" width="59" height="59" />
      </GuiSettings>
      <Properties>
        <Configuration />

As far as the file path goes, it looks it should work. 

Dan