Using Min and Max date from one Data Source

[anom23]

Hello, 

I have in interesting problem where I want to use the Min and Max date from my data to create an output name.  However I have two data sources with different dates but I want to use the Min and Max date from file A instead of file B.  When I union the files together, my output creates two separate files instead of 1.  Has anyone encountered an issue like this before?  Please see below at an example of how the initial files would appear in Alteryx. 

File A

Acct Number	Reason	Amount	Status	Min Status Change Date	Max Status Change Date
1111111	1.1	$100	Paid	6/21/2022	7/4/2022

File B

Acct Number	Reason	Amount	Status	Min Status Change Date	Max Status Change Date
22222	1.2	$50	Paid	4/11/2022	5/11/2022

End Result I am looking to achieve after both files have been unioned.

Test_06_21_2022 to 07_04_2022_Accounting.xls

[BrandonB · Accepted solution]

Just get the min and max dates from file A with a summarize tool and then append it after the union. That way you will have a consistent min and max date on every row. 

[anom23]

Wow...I am not sure why I didn't think about it that way but thank you.  It works perfectly!!

[BrandonB]

The thing to remember is that although a workflow is linear in nature and goes left to right, you can use data elements at any stage of your workflow downstream as well! Glad to help!