Tree function in section interface and Display problem

I rebuild my workflow and now i see results but only one row, do you know what i should change to collect all written information when someone use "Finish button" or "Run Workflow".

Second question is about option "Tree" which is available in section Interface in Toolbar.

I have problem to show information which chosen in Interface, because Alteryx show me only number but i want detailed information.

in attachment you can find my workflow.

e.g.

1) I choose second option and only A and C

2) In results I can see only number. The same is in Airline if i chose more then one Airline in table i see only one.

Thanks for the advice and help

Date_Input_2_design.yxwz

Input

Settings

Output

Apps

Accepted answers

NicoleJohnson

Aha! Now I see what you're asking.

Okay, you should be able to do that by bringing in your tree data source and then using some formulas & a Find and Replace tool to replace the numeric representation of your selections with the word versions.

See attached workflow that has this added branch to do the Find & Replace function. Basically, when you select your values in the tree, it brings over Key designation (1, 11, 12, 13, 2, 21, 22, 23, etc.) instead of the descriptions. So by bringing that table in separately (and using some formulas to create the right combined descriptions for each key value), you can then match those keys to the values from your chosen selections and return the description instead.

Hopefully looking at the workflow will make a bit more sense

Thanks!

Date_Input_2_design.yxwz

awojciechowski

thanks, i know about this two possibilities but I thought it would be possible to do something more automatically.

I found this https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/24946

but unfortunately it also require for me use "run" in second workflow.

All comments

NicoleJohnson

Ok, I think I know what's happening here... when you use the multiple-selection types of input tools, it will bring in all the values in one field with a delimiter between them.

For the Airlines example, the responses will come across in the following format, with "TRUE" or "FALSE" depending on the boxes checked:

40 MILE AIR=True,9G RAIL LIMITED=False,ABX AIR=True,ACCESRAIL=False,ACCTION AIRLINES=False,ADA AREOLINES DE ANTIQQUIA=False

So each option in your check list will be included in the cell with a comma between them. To get multiple lines to show up for your Airlines selections, you should use the Text to Columns tool, Split to Rows (instead of columns), and designate the , comma as your delimiter. You can then filter out the lines that have False and remove the "=True" from the end of each Airline selection that remains using a formula tool, etc.

For the Tree example, the responses come across with a new line delimiter for each new selection, again showing up all in one field. (You can tell this is what is happening in the example you show in your posting if you hover over the red triangle that pops up in the upper right corner of the field in the Results window... will tell you that there are new lines).

Include Specified Partners: A
Include Specified Partners: C

So to split this one out to rows, you will do the same as Airlines above, just using the new line delimiter \n to split the Partner Selection to new rows.

The end result will be one row for every combination of Airline + Partner Selection made. See attached, made some modifications (you'll need to reconnect the file you're using for your Tree, I had to make one up to get it to run on my machine). Questions, let me know!

Date_Input_2_design.yxwz

awojciechowski

Hi @NicoleJohnson

Unfortunately I don't know how it works, so I don't know how and what i should change to see in table one row with chosen options (not numbers).

If you can please share me final result and tell me step by step, what you change and why in this way, or/and if you know where i can find more knowledge about it please send me example of URL - I know that i need yet a lot of help but I'm still learning this smart application Alteryx.

I wiil be very grateful for all advice and helpful knowledge.

*In attachment is my example of "tree table".

Partner Selection.xlsx

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335