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.

1. 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.

2. Add two Microsoft Excel Output steps.

3. 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.

4. Create a hop from the last Filter row to the other Excel step. This time as the type for the hop, select Result is FALSE. The transformation looks as follows:

   

5. Double-click on the Filter rows step to edit it.

   Note

   Note that the content of the textboxes Send "true" data to step and Send...