Hey everyone,
I'm currently working on a project in Alteryx and I'm facing a challenge with consolidating date values for tasks assigned to different entities. Here's a brief overview of my problem:
I have a dataset where each row represents a task assigned to an entity. The dataset contains the following fields:
- Entity Name
- To provide data
- To provide first draft
- To approve
However, the data is currently structured in such a way that each task has its own row, potentially leaving empty rows between tasks for the same entity.
I'm looking for a way to consolidate these date values into one row, without any empty rows between the dates for each task. Can anyone suggest an approach or provide guidance on how I can achieve this using Alteryx?
Any help or advice would be greatly appreciated! :)
Thanks in advance!
