Multiple File Data Analysis

Question

So I have successfully pulled in a directory of multiple files with data from a single page from each of the multiple files. However, there are multiple instances of a specific material name in each file page and I want to filter my data to only the row of data from the first instance of the material name for each file.

For example, if my table looks like the below, I want to filter out the second time that the material name appears for each file name. I thought that I could do this using a sample tool and grouping by file name but that did not work. Any insights are much appreciated.

Material NameConsumption QtyFile NameOther dataFC2375 12000October 2024XXXX...FC2375112000October 2024XXXX...CX 31951100October 2024XXXX...

FC237513000November 2025XXXX...

FC23751000November 2025XXXX...

CX3195110000November 2025XXXX...

apathetichell · Answer

tile tool. unique value. select the combo of your two fields. filter tool ---> you want tile sequence number to equal 1.

DanM · Answer

@rdlouviere  If you can, add a Record ID, then sort the data by your Material Name. Check out the multi-row formula tool. You can group by each Material name and do an IF statement. Something like, if Material Name = Material Name Row-1 then Material Name Row-1 + 1 else 1 endif. That will then essentially create a new record ID for each Material Name row. You can then filter out the number 2 record and get the second row of data from each file.

https://community.alteryx.com/t5/Tool-Mastery/Tool-Mastery-Multi-Row-Formula/ta-p/86603