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
Solved! Go to 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.
Wow...I am not sure why I didn't think about it that way but thank you. It works perfectly!!
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!