BYU Student Author: @James_Behling
Reviewers: @Abraham_Reyes_Leon
Estimated Time to Solve: 15 Minutes
We provide the solution to this challenge using:
- Alteryx
Need a program? Click here.
Overview
In this challenge, you will use the “Block Until Done” activity in Alteryx to process a tax audit assignments dataset. The dataset contains multiple tax audits assigned to different auditors. Your goal is to ensure that each auditor’s data is written to a separate sheet in the same Excel workbook without causing writing conflicts (writing conflict errors can occur in Alteryx workflows when multiple processes attempt to write to the same Excel workbook simultaneously ).
To achieve this, you will:
-
Insert a “Block Until Done” activity to sequentially process outputs.
-
Use filters on each branch to filter the data based on the assigned auditor.
-
Write each auditor’s filtered data to a separate sheet in the same Excel workbook.
Instructions
Follow these steps to complete the challenge:
-
Download the provided dataset.
-
Use the “Input Data” tool (found in the In/Out category) to load the dataset into Alteryx.
-
Insert a “Block Until Done” tool to control the writing process.
-
From the outputs of “Block Until Done,” add filters to segment data based on the assigned auditor.
-
Connect each filtered data stream to an “Output Data” tool and write each outflow to the same Excel workbook, separated by sheets for each different Auditor. (View the suggestions and hints section to receive a hint on how to set this up!)
Reply to this challenge with a screenshot of your finished workflow. List one way that the block until tool could be beneficial in future workflows.
Data Files
Challenge253_Block_Until_Done.csv
Suggestions and Hints
To specify a sheet name of an Excel output, write “|||” and the desired sheet name after the excel file in the “Write to File or Database” input.
Example: ./Challenge253_Solution.xlsx|||Alice Johnson
Solution
Challenge253_Solution.xlsx
Solution Video: Challenge 253|ALTERYX – Block Until Done
