Date: Thu, 28 Mar 2024 08:47:04 +0000 (UTC) Message-ID: <697505107.67751.1711615624255@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_67750_1659472308.1711615624254" ------=_Part_67750_1659472308.1711615624254 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Command line allows you to exclude specific columns from data co= mpare.
Rules for excluding columns are as follows:
<Colum=
nPair>
of the <Columns>
element<Columns>
element should=
be set to ExcludeThe following xml fragment excludes the columns FIRST_NAME
,=
LAST_NAME
from the table HR.EMPLOYEES
and the co=
lumn ADDRESS
from the table HR.CUSTOMERS
:
<TablePairs>
<Pair>
<LeftObject Name=3D"H=
R.EMPLOYEES"></LeftObject>
<RightObject Name=3D"=
HR_COPY.EMPLOYEES"></RightObject>
<Columns Action=3D"Ex=
clude">
=
<ColumnPair>
=
<LeftColumn>FIRST_NAME</LeftColumn>
=
<RightColumn>FIRST_NAME</RightColumn>=
=
</ColumnPair>
=
<ColumnPair>
=
<LeftColumn>LAST_NAME</LeftColumn>
=
<RightColumn>LAST_NAME</RightColumn><=
br>
=
</ColumnPair>
</Columns>
</Pair>
<Pair>
<LeftObject Name=3D"H=
R.CUSTOMERS"></LeftObject>
<RightObject Name=3D"=
HR_COPY.CUSTOMERS"></RightObject>
<Columns Action=3D"Ex=
clude">
=
<ColumnPair>
=
<LeftColumn>ADDRESS</LeftColumn>
=
<RightColumn>ADDRESS</RightColumn>
=
</ColumnPair>
</Columns>
</Pair>
</TablePairs>