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
