Escape the Digital Dungeon
Hints
1)
Your first task is to merge the three tabs in the master file. You should join the “Users” tab with the “Installed Software” tab by matching on UserID. 2)
You should merge the “Software patching” dataset to this combined dataset. You can merge the data using the SoftwareName field.
3)
After setting up the data, you have to compare the major version of the installed software to the software patch version. The case states that the major version of the software is represented by the first set of digits in the software version, i.e., version 10.1.1 indicates that the major version is
10. 4)
Use the TexttoColumns
tools to separate out the first set of digits from the installed software version and patching software version. Watch this week’s video for a discussion of the
Textto Columns tool
.
5)
Use the Formula
tool to identify the employees whose installed software is not the latest version.
6)
EnergyYou then have to extract all the sales reports filed by these two employees from the 906 files in the Cybersecurity
_case_study_Digital_Dungeon_Potential Hacked_Files.zip file. 7)
You should use the Input Data
tool to bring these files into Alteryx. The documentation file (
https://help.alteryx.com/20231/designer/input-data-tool
) explains how to use wildcards (*) to simultaneously bring in multiple files.
8)
Once you have all the files for an employee, you should use the Data Cleansing
tool to extract all
the numbers in each cell. 9)
Since you need to sum these numbers, you should rearrange them from rows to columns. You can use the RegEx tool (within Parse) or access the REGEX_Replace
command in the Formula tool. Watch this week’s video for a discussion of regular expression and the
RegEx t
ool
.
