Filter with Value which gets changed everyday

[Ariz]

Hi all

Hope you are well, quick question just trying to use filter for a specific column to filter based on column next to it  or please advise whats the better way to filter any specific column based on the value provided in the next data. Please see the attached WF. 

Thanks in advance

Thanks

Ariz

[jdminton · Accepted solution]

@Ariz The Join Multiple tool brings back all records. It's similar to a full outer join in SQL. It would look closer to what you want if you joined by field versus record position, however, that will still return everything.

If you want to filter, use a regular join tool. Month should be set on the left and right as the fields, but it will remove any records not matching from the "J" output as they are joined. The left and right (L and R) show the records that did not join. I hope that helps.

 

[binuacs]

@Ariz A batch macro should work 

[Ariz]

Hey thanks for the prompt reply an this was a quick fix!!

[jdminton]

Awesome!