I use prep to connect and clean 2 data files each quarter, resulting in ONE new output file each quarter. I want to union a newly cleaned Prep file each quarter with my existing ones in Desktop. How do I do that? I thought I'd have a union option, but I'm not seeing it.
5 answers
1) Can the output be generated as an .xlsx ? They could then be union in Desktop.
2) Can both datasources be used in a single flow; but the cleaning process for each are separate flows within that single/master flow, then union both results ahead of the final output step?
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
