Add Field Name Based on Output of Another Tool

[Scott_Snowman]

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 #	TrueOrFalse	Quantity	Color
1	T	5	Red
2	F	7	Blue
3	T	9	Green

To this, I am trying to append the following:

Attribute

Shape

Texture

So my output would look like:

Record #	TrueOrFalse	Quantity	Color	Shape	Texture
1	T	5	Red
2	F	7	Blue
3	T	9	Green

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?

[MarqueeCrew · Accepted solution]

@Scott_Snowman,

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

Cheers,

Mark

[Scott_Snowman]

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!