Problem:
I joined two containers with the Union command and it produced staggered information.
Need: I need to move the the information that starts on Row 706 for columns Account Number, Description, Account Name and Amounts to Row 1
Solved! Go to Solution.
If you still have access to both data streams, I suggest replacing the Union Tool with a Join Tool (set to Join by position). This should accomplish exactly what you need. The only thing you'd need to do afterward is union all outputs ("L", "J", & "R") to account for the case where row count is different between data sets.
@CoG Thank you so much