Add Field Name Based on Output of Another Tool

Question

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 #TrueOrFalseQuantityColor1T5Red2F7Blue3T9Green

To this, I am trying to append the following:

AttributeShapeTexture

So my output would look like:

Record #TrueOrFalseQuantityColorShapeTexture1T5Red  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?

MarqueeCrew · Accepted Answer

@Scott_Snowman,

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

Cheers,

Mark