​​​​Ed Orlando​

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