Free Trial

Alteryx Designer Desktop Discussions

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

Tree Interface for County_State_City

knozawa
11 - Bolide

Hi,

 

I was following this link to set up the tree interface.

I would like to have Region --> State --> City tree interface.

 

However, the output was not I was expected.  There are multiple cities missing under state.

Sample Tree Interface example.png

 

I thought the problem is due to the tile tool. Using the tile tool creates only 10 categories because there are only 1-9 numbers.  However, when I looked at the West region using the interface designer, there are 12 states on the list.

 

Does anyone know how to deal with this problem?

 

Thank you,

Kazumi

 

2 REPLIES 2
jrgo
14 - Magnetar

@knozawa,

 

i think it's a simple fix... 

 

In your formula tool that concatenates the keys, the level 3 key needs some adjustment.

image.png 

Delete the Level 1 key from what your concatenating and that should generate your tree list properly.

 

image.png

knozawa
11 - Bolide

@jrgo,

 

Thank you very much!

 

Kazumi

Labels
Top Solution Authors