Problem Appending / Filtered Data in Excel

Help StudioX
,
1

I am trying to filter data in one Excel Sheet (OPADB) by a Number (NEID) per row in another (Roster) and then compile the results in a third sheet (CurrentOPA). I configured it exactly the same way as I did in a previous automation where I copied the filtered results to separate sheets for each name. The only difference is that I used Copy/Paste in that one instead of Append and copied it to separate spreadsheets instead of one.

The problem I’m having is that it seems to be filtering correctly, but it’s copying the unfiltered results, i.e. the entire table to the new spreadsheet each time except for the first row.

Here is my sequence.

This image depicts an automated workflow, likely from a process automation software, involving operations on an Excel file to filter and append data from a specific column within an Excel sheet. (Captioned by AI)
This image depicts an automated workflow, likely from a process automation software, involving operations on an Excel file to filter and append data from a specific column within an Excel sheet. (Captioned by AI)1194×1038 27.2 KB

Any feedback would be appreciated. Thanks!

2

@justindward

This append range will always read full data without considering filters

You need to use read range with filters option and then append range with datatable as input

Cheers