Add Field Name Based on Output of Another Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It looks like you want to crosstab the 2nd data after you add a blank value to it:
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!