In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Split each field in a table to separate tables

rgusaas
8 - Asteroid
‎06-12-2017 09:07 AM

I need to split each field in a large table into separate tables. I know how to do it using the Select tool but wondered if there was another method that would save me the time of mapping 330 fields. I will only want the distinct values for each field also.

 

Any ideas would be greatly appreciated.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎06-12-2017 09:17 AM

Using a TRANSPOSE tool followed by a Summarize, you'll get the sets of field names and values that are unique.  I then use the field name to help construct the table name and create equal tables all having 1 column of "Value" containing the unique set of domain values for the given field name.

 

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.
TABLE OF FIELD DOMAIN VALUES.yxmd
Reply
Alteryx One Admin Experience
Labels
Top Solution Authors
View All