how to create column and sub column
- 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
Hello Everyone,
Need help on to create column and sub column.
input : column name is 1,2,3,6,7,8 like this
Output
appreciate your help !
Thanks in Advance !
- Labels:
- Best Practices
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Ekmi9,
Do you want this output in Excel? In Alteryx no such thing as a "sub column" exists. Merging cells also doesn't work. Alteryx is not really ment to be used for such a format (no data tool is).
An Alteryx approach for something like this would be to create a column that contains A or B, instead of each column carring that value each row would do so.
This does something similar:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you really want to present your data in this way, you can use several reporting tools to achieve that.But it is not recommended because Alteryx is not a good reporting tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sparksun can i have this workflow please want to check how you join two table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator