Consolidating data multiple sources
Data harmonization in healthcare is difficult because of the high level of ambiguity and complexity in the data concepts themselves.
Here we have two source files an Order Header and an Order Detail.
Other organizations made poor design choices inserting mandatory fields at inopportune times during patient care that led to workarounds and bad data capture.
Local EHR configuration and workflows directly determine how data is captured, and ultimately, the interoperability, quality and re-usability of the data for other purposes.
First if you right click on "Flat File Source" and select the "Show Advanced Editor".
On the Input and Output Properties tab you need to change the "Is Sorted" to True for both of the Flat File Sources.