Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Dynamic Append based on Column

Highlighted
5 - Atom

Hello everybody, 

 

i have the following table, which includes different dimension types and corresponding dimension data:

Dim_TypeDim_Index
11
12
21
22
23

 

Based on this i need to create the following table, which has Dim_Types as header and includes all combinations of the Dim_Index in the rows:

Dim_Type_1Dim_Type_2
11
12
13
21
22
23

 

Currently i am achieving this by using multiple filter and append field tools. But as the solution has to work for different datasets with different dimension types, i would like to do it dynamically so it automatically works for more dimension types. 

 

Is there a "smarter" way to dynamically append the fields to generate this table?

 

Thanks!

 

Highlighted
Alteryx Partner
Alteryx Partner

Hey @manjuul 

 

There are going to be many ways to solve this problem but this is one way. I didn't handle your header names but the unique values will scale to however many you have. 

 

Hope this helps! 

Highlighted
5 - Atom

Hi Joshua, 

 

thanks for your fast reply. Unfortunately its not quite what i'm trying to achieve, as it does not generate new columns for each "Dim_Type". I'm looking for something that works like the workflow i attached, but for a dynamic count of Dim_Type and Dim_Index.

Is it possible to achieve something like this?

 

Best Regards

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hey @manjuul 

 

I don't think this is possible in pure Alteryx. Happy to be wrong. See my Python based solution attached,

 

PhilipMannering_0-1605876392302.png

 

 

 

Highlighted
5 - Atom

Hi Philip,

 

indeed this seems to work. Maybe its time to get more into Python. 

 

Thanks!

Labels