<turbo-stream action="update" target="wiki_card"><template>

<h1>Sorting Destination Table</h1>
<div class="trix-content"><h3>Overview</h3><ul><li>When data is transferred between two tables, Rapidi works through the records in the order they are returned from the source database server.</li><li>After reading a record from the source table, Rapidi will normally (depending on the functionality selected) make a lookup in the destination table using the Table Link specified.</li><li>In some cases, you can optimize performance by selecting a specific sorting. This is specifically true if you are using MS Dynamics NAV with a native database - here the sorting will be used to select a key and selecting a key that contains the fields used in the Table Link or in Delimitation is very important for MS Dynamics NAV native database.</li><li>If running on a SQL-based system, the sorting will translate into an "Order By" in the select statement.</li><li>When using the Source Control feature, Rapidi automatically sets the sorting to the field used as Source Control and you should not specify Sorting Source Table in this case.</li></ul><h3>Field:</h3><p>Here you specify the field(s), you want your data to be sorted by. If you need data sorted by more than one field, enter these on separate lines.</p></div>
</template></turbo-stream>

