finding what days a unique identifier is included in unique daily files

[Ksisterhen]

Hi-

We have files saved daily with a uniform title, file 1 5.3, file 1 5.4 file 1 5.5, etc.  I want to set up a workflow to tell me if unique values in column 1 of the 5.3 file are in the 5.4 file and if not listed which ones dropped and if in the 5.4 file but not the 5.3 file to let me know of those new unique codes

[arods]

Hi I would use the unique tool then do a find replace in the unique anchor to see what lines are duplicate and remove them, then with a filter then I would use a find replace to find the values in the other files, it's hard to explain without your database if you could provide the files you were using it would hep me 

[binuacs]

@Ksisterhen as @arods mentioned provide some sample input files and expected output for a better understanding of your use case

[Ksisterhen]

see example reports below, the final report example is what i'm looking to get as my output in excel. these are made up files but i have daily files like this for april that i am trying to combine to get a final report

[binuacs]

@Ksisterhen Not a dynamic solution