Skip to main content
Skip table of contents

getTableIntersection

This procedure compares the metadata of the source and target and generates the column lists for data download based on the intersection of the columns in the source and target. It also allows adding the mandatory columns at the beginning and the end of the resultset by using the corresponding parameters. The values for these columns are not returned in source_columns and must be specified explicitly in the consuming procedure.

Parameters

ParameterDescription
source_datasetFully-qualified name of the source. Can be an existing table or a stored procedure returning data. Can also be an arbitrary table specification in the form of a string: $column1|dataType1,column2|dataType3,column3[|string] returning data; mandatory
target_tableFully-qualified name of the target. Must be an existing table; mandatory
isSourceATableTRUE or NULL if the source is a table, FALSE if it is a procedure
collapseEqualDatasetsReturns a simple * if the metadata of source and target fully matches
renamedColumnsComma-separated list of columns pairs separated by vertical bars: NameInTarget1|NameInSource1, NameInTarget1|NameInSource1
ignoredColumnChangesComma-separated list of columns for which no warning should be raised (which are expected due to the intended logic or known changes)
excludedColumnsColumns to exclude from the source
columnListFirstColumns to add in the beginning
columnListLastColumns to add in the end

Attributes

Attribute

Type

target_columns

clob

source_columns

clob

Columns that only exist in the source or target are excluded from the output. Columns with the same names but different data types will be attempted to be converted automatically using UTILS.tryCast . If the cast fails, NULL values will be inserted.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.