Alteryx - Data massaging
- 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,
If my Data is like this and i want total of last column (wont mind total of all columns) then what is the way to do it in alteryx?
xyz | |||||||
EQ | |||||||
1/31/2023 | |||||||
1291722 | A | SDSD | 6682 | 112.68 | 84986473 | 112.68 | 84986473 |
97916423 | B | HJHJ | 960 | 70.12 | 77474737 | 70.12 | 77474737 |
69723297 | C | GJGI | 80689 | 24.28 | 94976474 | 24.28 | 94976474 |
979329 | D | IUGI | 5985 | 172.74 | 4747747 | 172.74 | 4747747 |
70773070 | E | GKG | 495 | 43.51 | 2874401.13 | 43.51 | 2874401.13 |
- Labels:
- Datasets
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ilovecoding Another option to calculate the column's total was using the transpose and the cross tab tool. The cross tab tool has the options to calculate column total and row total
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for response, how did you get Field1 field2 labels? My file doesn't have it and i don't want to write that manually in excel before executing in alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ilovecoding you can connect your excel input file in the given workflow. If your excel file doesn't have any column heading, use the below option in the input tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My source file format is .csv so when i chose select function i see only 2 options rather than several columns. First row contains field names is already checked