Differences

This shows you the differences between two versions of the page.

--- transformations:selectdbrowsbykeys [2021/03/12 20:50] – craigt
+++ transformations:selectdbrowsbykeys [2021/04/08 23:49] (current) – craigt
@@ Line 1: / Line 1: @@
 {{ transformations:SelectDbRowsAction.png}}
 ======SELECT MATCHING DATABASE ROWS======
-Category: Import / Database
+Category: Import / Database\\
+\\
 =====Description=====
-Selects rows from a database table where a combination of key fields matches a combination of key fields in an EasyMorph table.
+Selects rows from a database table where a combination of key fields matches a combination of key fields in an EasyMorph table. \\
-Under the hood, the action creates a temporary table in the target database, uploads key field combinations into it, and performs a SELECT..WHERE..EXISTS statement. After the statement is executed the temporary table is deleted.\\
 \\
@@ Line 13: / Line 12: @@
 Another use case is //cross-source filtering// which means importing database records having IDs that are obtained from another data source (e.g. text file or spreadsheet).\\
+\\
+=====Remarks=====
+Under the hood, the action creates a temporary table in the target database, uploads key field combinations into it, and performs a SELECT..WHERE..EXISTS statement. After the statement is executed the temporary table is deleted.\\
 \\