Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
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