Multiple File Data Analysis

[rdlouviere]

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 Name	Consumption Qty	File Name	Other data
FC2375	12000	October 2024	XXXX...
FC2375	112000	October 2024	XXXX...
CX 3195	1100	October 2024	XXXX...
FC2375	13000	November 2025	XXXX...
FC2375	1000	November 2025	XXXX...
CX3195	110000	November 2025	XXXX...

[DanM]

@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

[apathetichell]

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