top of page
Ed Orlando
Data Scientist | White Lodging
Alteryx Weekly Challenge #19
Excel Record Locator
https://community.alteryx.com/t5/forums/recentpostspage/user-id/19037
Use Case:
Customer has 100's of xls files with 1 common sheet available in all workbooks. Through one process, the user would like to read across all of the xls files and return the values contained in specific cells - Row 2, Column 3 and Row 8, Column 2 from Sheet1 in each XLS workbook.
The result should be a table OR browse tool containing 3 columns:
XLS File, Row2_ Column3, and Row8_Column2.
You will only have 2 xls files as input for this exercise - Book1 and Book2. The sheet you should use is called Sheet 1.
****For all data consumption, please check the box for First Row Contains Data
Data Set #1 Data Set #2
Final Data Set Solution
Workflow with Detail












bottom of page