Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Add Field Name Based on Output of Another Tool

Scott_Snowman
10 - Fireball

I've just gotten started with Alteryx, and this question is stumping me.

 

I have been given a workflow with cross-tabbed records as the output. I've pulled out some of the intermediate output and used that to generate secondary output, which is incremental fields that I'd like to add to the cross-tabbed records.

 

How can I systematically append fields onto cross-tabbed data?

 

Here's an example. Cross-tabbed data:

 

Record #TrueOrFalseQuantityColor
1T5Red
2F7Blue
3T9Green

 

To this, I am trying to append the following:

 

Attribute
Shape
Texture

 

So my output would look like:

 

Record #TrueOrFalseQuantityColorShapeTexture
1T5Red  
2F7Blue  
3T9Green  

 

I can't figure out how to get the fields on there. (Populating them with the relevant data is another issue entirely, but I figure I'll give that a try once I have the fields present. My hunch is a multi-field formula will be my first stop.)

 

Note that my "Attribute" Table will vary based on the initial input, so I need to systematically append the fields.

 

Any suggestions?

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Scott_Snowman,

 

It looks like you want to crosstab the 2nd data after you add a blank value to it:

 

Capture.png

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Scott_Snowman
10 - Fireball

That's it exactly -- I got stumped because the Cross Tab tool wouldn't operate without a second column, and I didn't think to just... insert one in there.

 

Thank you!

Labels
Top Solution Authors