Column Merge
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Sarath27
8 - Asteroid
‎10-19-2023
12:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I am trying to merge columns similar to excel.
Pls find the attachment for your reference both screenshot & excel file and kindly help me achieving this.
Labels:
- Labels:
- Data Investigation
5 REPLIES 5
17 - Castor
‎10-19-2023
01:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-19-2023
03:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks much. I need to have a blank column after every grand total. i.e after 2023_07_31_Grand_Total there should be a blank column where next date should start.
17 - Castor
‎10-19-2023
03:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can add a column by using the Formula tool and title it as "Blank". Then use a Select tool to put some space between them.
If you have multiple, then you can add a row in te cross-tab/transpose section I did.
Try it out and let me know. If you're stuck, I'll show you how. The clues above should teach you.
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
‎10-19-2023
03:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am kind of confused of where I should add formula tool, pls assist me on this.
17 - Castor
‎10-19-2023
03:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
