Oldest Date data extracted from multi files

[k3pineapple]

Dear all,

Seeking your help to using "Directory" function to extract enablement date stats from multi files.

Logic here is:

1. Recording most first enablement date into the output file 

2. If user somehow being suspended, and re-enable, still use the previous enablement date.

Much appreciated for your time

Sample Input

Company	Product	User	ModiDate	Status
ABC	Apple	Amy	2/11/2020	Enabled
ABC	Banana	Amy	2/11/2020	Enabled
DEF	Apple	Bob	5/3/2020	Pending
DEF	Banana	Bob	5/3/2020	Pending

Company	Product	User	ModiDate	Status
ABC	Apple	Amy	2/11/2021	Suspended
ABC	Banana	Amy	2/11/2021	Suspended
DEF	Apple	Bob	5/3/2021	Enabled
DEF	Banana	Bob	5/3/2021	Enabled
DEF	Apple	Cindy	5/18/2021	Pending
DEF	Cherry	Cindy	5/18/2021	Pending

Company	Product	User	ModiDate	Status
ABC	Apple	Amy	5/18/2022	Enabled
ABC	Banana	Amy	5/18/2022	Enabled
DEF	Apple	Bob	5/3/2021	Enabled
DEF	Banana	Bob	5/3/2021	Enabled
DEF	Apple	Cindy	5/18/2022	Enabled
DEF	Cherry	Cindy	5/18/2022	Enabled

Sample Output

Company	Product	User	ModiDate	Status
ABC	Apple	Amy	2/11/2020	Enabled
ABC	Banana	Amy	2/11/2020	Enabled
DEF	Apple	Bob	5/3/2021	Enabled
DEF	Banana	Bob	5/3/2021	Enabled
DEF	Apple	Cindy	5/18/2022	Enabled
DEF	Cherry	Cindy	5/18/2022	Enabled

[jdminton]

I don't think you were really asking about the directory tool, but I'm not sure what you meant by directory function. In any event, here is how you can achieve your goal.

 

[k3pineapple]

@jdminton thx for this design, my struggle is, there are over 30+ files stored in one folder and will have more later. I would like to compare all date data in every file across in this folder. I suppose directory tool should be the better one to use?

[jdminton · Accepted solution]

You really have a couple of other options. See the one with directory and dynamic input and also the one using an input tool with a wildcard.