Our team has a sales file that is published daily. Sometimes we want to examine changes between two dates. I can use Alteryx to isolate what is common vs in one file and not the other using the join. What I want to do for the left outer join is how to add a column to those results to tell anyone reviewing that file that is is from the file from date A. The right join would be results from the file from date B. How do I append a column for Left and Right join results to differentiate the date for the respective files in the join?
