Time for action – assigning tasks by filtering priorities with the Filter rows step
Continuing with the JIRA subject, let's do a more realistic distribution of tasks among programmers. Let's assign the severe task to our most experienced programmer, and the other tasks to others.
Create a new transformation.
Read the JIRA file and filter the unassigned tasks, just as you did in the previous section.
- Add a Filter rows step. Create a hop from the previous Filter rows step toward this new filter. When asked for the kind of hop, select Main output of step.
- Add two Microsoft Excel Output steps.
- Create a hop from the last Filter row to one of the Microsoft Excel Output steps. As the type for the hop, select Result is TRUE.
- Create a hop from the last Filter ...