Is there a way to combine data within just 1 excel spreadsheet using Alteryx?
Example:
Column A (Name) Column B (Date) Column C (Time) Column D (Work Category)
Row 1 John Doe 1/1/19 1.5 B1
Row 2 John Doe 1/1/19 1 B2
Row 3 John Doe 1/1/19 1.5 C3
Row 4 John Doe 1/2/19 2 A2
Row 5 John Doe 1/2/19 1.5 B3
Row 6 Jane Doe 1/1/19 1.5 A4
Row 7 Jane Doe 1/1/19 2 B3
I'm looking to sum column C hours by date and combine column D data with comma separators.
Example:
Row 1 John Doe 1/1/19 4 B1, B2, C3
Row 2 John Doe 1/2/19 3.5 A2, B3
Row 3 Jane Doe 1/1/19 3.5 A4, B3
Solved! Go to Solution.
What you'd like to do is to use the Summarize tool in the following configuration
Very helpful, thank you!
Is there also a way to remove decimals from a number starting with zero?
I have something like this:
0.781823.45 and want it changed to 078182345