topic Re: Compare data between two tables in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956386#M11080 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/189160">@Luis171190</a>&nbsp; Not sure of your exact requirement though. But see the script below that I have used.</P> <P>NoConcatenate<BR />Temp:<BR />Load * Inline [<BR />ID MATERIAL TEXT_BRIEF_MATERIAL<BR />1 10658373 RUP ULTRAMAX,AR,64x15KG BOX<BR />2 10699860 RUP ULTRAMAX,UY, 64X15KG BOX<BR />3 10699861 RUP ULTRAMAX,BO, 64X15KG BOX<BR />4 10699862 RUP ULTRAMAX,CL, 64X15KG BOX<BR />5 10699863 RUP ULTRAMAX,PY, 64X15KG BOX<BR />6 12331311 RUP CONTROLMAX,AR,64x15KG BOX<BR />7 12386330 SUPER ESTRELLA GR 79,2 ACA, AR, 64X15KG<BR />8 12386332 SUPER ESTRELLA GR 79,2, AR, 64X15KG BOX<BR />9 10659812 RUP FG,AR,64X15KG BOX<BR />10 10699865 RUP FG,CL,64X15KG BOX<BR />11 10699867 RUP FG,PY,64X15KG BOX<BR />12 11984610 RUP FG,PY,64X15KG BOX MON76813<BR />13 11984611 RUP FG,BO,64X15KG BOX MON76813<BR />14 12383711 RUP FG L,AR,64X15KG BOX MON76934<BR />15 12806191 RUP FG,BO,64X15KG BOX MON76934<BR />16 10434287 RUP FULL II,AR,48x20L BT MON78864<BR />17 10434315 ROUNDUP FULL II,CL,48x20L BT MON78864<BR />18 10434317 ROUNDUP FULL II,PY,48x20L BT MON78864<BR />19 10434318 RUP FULL II,UY,48x20L BT MON78864<BR />20 10434319 RUP FULL II,BO,48x20L BT MON78864<BR />21 12947119 RUP FULL II,AR,48x20L BT MON301511<BR />22 10434277 HARNESS,AR,48x20L BT MON58415<BR />23 11953281 LA TIJERETA BOX, AR,64X15KG,BOX MON76813<BR />24 12870047 LA TIJERETA BOX, PY,64X15KG,BOX MON76813<BR />25 12109370 LA TIJERETA BOX, PY,64X15KG,BOX MON76813<BR />26 12383710 LA TIJERETA BOX L,AR,64X15KG,BOX MON7693<BR />27 12457272 LA TIJERETA BOX, BO, 64X15KG, MON76813<BR />28 12806192 LA TIJERETA BOX, BO, 64X15KG, MON76813<BR />29 11754119 LA TIJERETA II, AR, 48X20L BT MON 76690<BR />30 11699473 LA TIJERETA PLATINUM,MON76567,48X20L,BT<BR />31 12457273 LA TIJERETA PLATINUM, BO, MON76567<BR />32 10664941 SUPER ESTRELLA II, AR,48X20L BT MON78864<BR />33 12274427 SUPER ESTRELLA II ACA, AR, 48X20L BT<BR />34 12698505 POWER PLUS DRY, AR, 64X15KG BOX MON76934<BR />35 12274425 SUPER ESTRELLA GR ACA, AR, 64X15KG BOX <BR />36 11293612 COUNTACH KOH 480, MON76567, 48X20L BT<BR />37 11292224 SNIPER KOH 480, MON76567, 48X20L BT<BR />38 12643147 SNIPER DRY, AR, 64X15KG BOX MON76934<BR />](delimiter is '');</P> <P>Right join (Temp)<BR />Temp1:<BR />Load * inline [<BR />ID DATE DAY MONTH YEAR HOUR MATERIAL<BR />1 20220103 3 1 2022 9 10434317<BR />2 20220103 3 1 2022 9 10434318<BR />3 20220103 3 1 2022 9 10434319<BR />4 20220103 3 1 2022 9 10434323<BR />5 20220103 3 1 2022 9 10434326<BR />6 20220103 3 1 2022 9 10434337<BR />7 20220103 3 1 2022 9 10434338<BR />8 20220103 3 1 2022 9 10434339<BR />9 20220103 3 1 2022 9 10434340<BR />10 20220103 3 1 2022 9 10434347<BR />11 20220103 3 1 2022 9 10434353<BR />12 20220103 3 1 2022 9 10434354<BR />13 20220103 3 1 2022 9 10434356<BR />14 20220103 3 1 2022 9 10434373<BR />15 20220103 3 1 2022 9 10434374<BR />16 20220103 3 1 2022 9 10434382<BR />17 20220103 3 1 2022 9 10434385<BR />18 20220103 3 1 2022 9 10434388<BR />19 20220103 3 1 2022 9 10434389<BR />20 20220103 3 1 2022 9 10434390<BR />21 20220103 3 1 2022 9 10434393<BR />22 20220103 3 1 2022 9 10434394<BR />23 20220103 3 1 2022 9 10434395</P> <P>](delimiter is '');</P> <P>exit Script;</P> Fri, 15 Jul 2022 10:39:23 GMT sidhiq91 2022-07-15T10:39:23Z Compare data between two tables https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956270#M11072 <P>Good morning! Could you please help me. I have these two tables loaded from two different Excel, I need to take the 'MATERIAL' data from table 1 and overwrite the 'MATERIAL' data from table 2.</P> <P>&nbsp;</P> <P>TABLE 1</P> <TABLE width="382"> <TBODY> <TR> <TD width="80">MATERIAL</TD> <TD width="302">TEXT_BRIEF_MATERIAL</TD> </TR> <TR> <TD>10658373</TD> <TD>RUP ULTRAMAX,AR,64x15KG BOX</TD> </TR> <TR> <TD>10699860</TD> <TD>RUP ULTRAMAX,UY, 64X15KG BOX</TD> </TR> <TR> <TD>10699861</TD> <TD>RUP ULTRAMAX,BO, 64X15KG BOX</TD> </TR> <TR> <TD>10699862</TD> <TD>RUP ULTRAMAX,CL, 64X15KG BOX</TD> </TR> <TR> <TD>10699863</TD> <TD>RUP ULTRAMAX,PY, 64X15KG BOX</TD> </TR> <TR> <TD>12331311</TD> <TD>RUP CONTROLMAX,AR,64x15KG BOX</TD> </TR> <TR> <TD>12386330</TD> <TD>SUPER ESTRELLA GR 79,2 ACA, AR, 64X15KG</TD> </TR> <TR> <TD>12386332</TD> <TD>SUPER ESTRELLA GR 79,2, AR, 64X15KG BOX</TD> </TR> <TR> <TD>10659812</TD> <TD>RUP FG,AR,64X15KG BOX</TD> </TR> <TR> <TD>10699865</TD> <TD>RUP FG,CL,64X15KG BOX</TD> </TR> <TR> <TD>10699867</TD> <TD>RUP FG,PY,64X15KG BOX</TD> </TR> <TR> <TD>11984610</TD> <TD>RUP FG,PY,64X15KG BOX MON76813</TD> </TR> <TR> <TD>11984611</TD> <TD>RUP FG,BO,64X15KG BOX MON76813</TD> </TR> <TR> <TD>12383711</TD> <TD>RUP FG L,AR,64X15KG BOX MON76934</TD> </TR> <TR> <TD>12806191</TD> <TD>RUP FG,BO,64X15KG BOX MON76934</TD> </TR> <TR> <TD>10434287</TD> <TD>RUP FULL II,AR,48x20L BT MON78864</TD> </TR> <TR> <TD>10434315</TD> <TD>ROUNDUP FULL II,CL,48x20L BT MON78864</TD> </TR> <TR> <TD>10434317</TD> <TD>ROUNDUP FULL II,PY,48x20L BT MON78864</TD> </TR> <TR> <TD>10434318</TD> <TD>RUP FULL II,UY,48x20L BT MON78864</TD> </TR> <TR> <TD>10434319</TD> <TD>RUP FULL II,BO,48x20L BT MON78864</TD> </TR> <TR> <TD>12947119</TD> <TD>RUP FULL II,AR,48x20L BT MON301511</TD> </TR> <TR> <TD>10434277</TD> <TD>HARNESS,AR,48x20L BT MON58415</TD> </TR> <TR> <TD>11953281</TD> <TD>LA TIJERETA BOX, AR,64X15KG,BOX MON76813</TD> </TR> <TR> <TD>12870047</TD> <TD>LA TIJERETA BOX, PY,64X15KG,BOX MON76813</TD> </TR> <TR> <TD>12109370</TD> <TD>LA TIJERETA BOX, PY,64X15KG,BOX MON76813</TD> </TR> <TR> <TD>12383710</TD> <TD>LA TIJERETA BOX L,AR,64X15KG,BOX MON7693</TD> </TR> <TR> <TD>12457272</TD> <TD>LA TIJERETA BOX, BO, 64X15KG, MON76813</TD> </TR> <TR> <TD>12806192</TD> <TD>LA TIJERETA BOX, BO, 64X15KG, MON76813</TD> </TR> <TR> <TD>11754119</TD> <TD>LA TIJERETA II, AR, 48X20L BT MON 76690</TD> </TR> <TR> <TD>11699473</TD> <TD>LA TIJERETA PLATINUM,MON76567,48X20L,BT</TD> </TR> <TR> <TD>12457273</TD> <TD>LA TIJERETA PLATINUM, BO, MON76567</TD> </TR> <TR> <TD>10664941</TD> <TD>SUPER ESTRELLA II, AR,48X20L BT MON78864</TD> </TR> <TR> <TD>12274427</TD> <TD>SUPER ESTRELLA II ACA, AR, 48X20L BT</TD> </TR> <TR> <TD>12698505</TD> <TD>POWER PLUS DRY, AR, 64X15KG BOX MON76934</TD> </TR> <TR> <TD>12274425</TD> <TD>SUPER ESTRELLA GR ACA, AR, 64X15KG BOX &nbsp;</TD> </TR> <TR> <TD>11293612</TD> <TD>COUNTACH KOH 480, MON76567, 48X20L BT</TD> </TR> <TR> <TD>11292224</TD> <TD>SNIPER KOH 480, MON76567, 48X20L BT</TD> </TR> <TR> <TD>12643147</TD> <TD>SNIPER DRY, AR, 64X15KG BOX MON76934</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>TABLE 2</P> <TABLE style="border-collapse: collapse; width: 360pt;" border="0" width="480" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="80" height="20" class="xl65" style="height: 15.0pt; width: 60pt;">DATE</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">DAY</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">MONTH</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">YEAR</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">HOUR</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">MATERIAL</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434317</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434318</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434319</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434323</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434326</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434337</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434338</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434339</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434340</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434347</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434353</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434354</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434356</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434373</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434374</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434382</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434385</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434388</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434389</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434390</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434393</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434394</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434395</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you so much!!</P> Fri, 15 Jul 2022 07:32:07 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956270#M11072 Luis171190 2022-07-15T07:32:07Z Re: Compare data between two tables https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956273#M11073 <P>How do you mean over overwrite?</P> <P>To me it looks like the Material is a key field and you just want to join the two tables?</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Jul 2022 07:35:39 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956273#M11073 Mark_Little 2022-07-15T07:35:39Z Re: Compare data between two tables https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956275#M11074 <P>Sorry, I omitted the braces, I'll go through the example again. I need the values of the 'MATERIAL' column of table1 to have the same values I want in table2 for the 'MATERIAL' column. I understand that there will be a synthetic key for having two keys but I remove them later with a linktable.</P> <P>&nbsp;</P> <P>Table1</P> <P>&nbsp;</P> <TABLE width="462"> <TBODY> <TR> <TD width="80">ID</TD> <TD width="80">MATERIAL</TD> <TD width="302">TEXT_BRIEF_MATERIAL</TD> </TR> <TR> <TD>1</TD> <TD>10658373</TD> <TD>RUP ULTRAMAX,AR,64x15KG BOX</TD> </TR> <TR> <TD>2</TD> <TD>10699860</TD> <TD>RUP ULTRAMAX,UY, 64X15KG BOX</TD> </TR> <TR> <TD>3</TD> <TD>10699861</TD> <TD>RUP ULTRAMAX,BO, 64X15KG BOX</TD> </TR> <TR> <TD>4</TD> <TD>10699862</TD> <TD>RUP ULTRAMAX,CL, 64X15KG BOX</TD> </TR> <TR> <TD>5</TD> <TD>10699863</TD> <TD>RUP ULTRAMAX,PY, 64X15KG BOX</TD> </TR> <TR> <TD>6</TD> <TD>12331311</TD> <TD>RUP CONTROLMAX,AR,64x15KG BOX</TD> </TR> <TR> <TD>7</TD> <TD>12386330</TD> <TD>SUPER ESTRELLA GR 79,2 ACA, AR, 64X15KG</TD> </TR> <TR> <TD>8</TD> <TD>12386332</TD> <TD>SUPER ESTRELLA GR 79,2, AR, 64X15KG BOX</TD> </TR> <TR> <TD>9</TD> <TD>10659812</TD> <TD>RUP FG,AR,64X15KG BOX</TD> </TR> <TR> <TD>10</TD> <TD>10699865</TD> <TD>RUP FG,CL,64X15KG BOX</TD> </TR> <TR> <TD>11</TD> <TD>10699867</TD> <TD>RUP FG,PY,64X15KG BOX</TD> </TR> <TR> <TD>12</TD> <TD>11984610</TD> <TD>RUP FG,PY,64X15KG BOX MON76813</TD> </TR> <TR> <TD>13</TD> <TD>11984611</TD> <TD>RUP FG,BO,64X15KG BOX MON76813</TD> </TR> <TR> <TD>14</TD> <TD>12383711</TD> <TD>RUP FG L,AR,64X15KG BOX MON76934</TD> </TR> <TR> <TD>15</TD> <TD>12806191</TD> <TD>RUP FG,BO,64X15KG BOX MON76934</TD> </TR> <TR> <TD>16</TD> <TD>10434287</TD> <TD>RUP FULL II,AR,48x20L BT MON78864</TD> </TR> <TR> <TD>17</TD> <TD>10434315</TD> <TD>ROUNDUP FULL II,CL,48x20L BT MON78864</TD> </TR> <TR> <TD>18</TD> <TD>10434317</TD> <TD>ROUNDUP FULL II,PY,48x20L BT MON78864</TD> </TR> <TR> <TD>19</TD> <TD>10434318</TD> <TD>RUP FULL II,UY,48x20L BT MON78864</TD> </TR> <TR> <TD>20</TD> <TD>10434319</TD> <TD>RUP FULL II,BO,48x20L BT MON78864</TD> </TR> <TR> <TD>21</TD> <TD>12947119</TD> <TD>RUP FULL II,AR,48x20L BT MON301511</TD> </TR> <TR> <TD>22</TD> <TD>10434277</TD> <TD>HARNESS,AR,48x20L BT MON58415</TD> </TR> <TR> <TD>23</TD> <TD>11953281</TD> <TD>LA TIJERETA BOX, AR,64X15KG,BOX MON76813</TD> </TR> <TR> <TD>24</TD> <TD>12870047</TD> <TD>LA TIJERETA BOX, PY,64X15KG,BOX MON76813</TD> </TR> <TR> <TD>25</TD> <TD>12109370</TD> <TD>LA TIJERETA BOX, PY,64X15KG,BOX MON76813</TD> </TR> <TR> <TD>26</TD> <TD>12383710</TD> <TD>LA TIJERETA BOX L,AR,64X15KG,BOX MON7693</TD> </TR> <TR> <TD>27</TD> <TD>12457272</TD> <TD>LA TIJERETA BOX, BO, 64X15KG, MON76813</TD> </TR> <TR> <TD>28</TD> <TD>12806192</TD> <TD>LA TIJERETA BOX, BO, 64X15KG, MON76813</TD> </TR> <TR> <TD>29</TD> <TD>11754119</TD> <TD>LA TIJERETA II, AR, 48X20L BT MON 76690</TD> </TR> <TR> <TD>30</TD> <TD>11699473</TD> <TD>LA TIJERETA PLATINUM,MON76567,48X20L,BT</TD> </TR> <TR> <TD>31</TD> <TD>12457273</TD> <TD>LA TIJERETA PLATINUM, BO, MON76567</TD> </TR> <TR> <TD>32</TD> <TD>10664941</TD> <TD>SUPER ESTRELLA II, AR,48X20L BT MON78864</TD> </TR> <TR> <TD>33</TD> <TD>12274427</TD> <TD>SUPER ESTRELLA II ACA, AR, 48X20L BT</TD> </TR> <TR> <TD>34</TD> <TD>12698505</TD> <TD>POWER PLUS DRY, AR, 64X15KG BOX MON76934</TD> </TR> <TR> <TD>35</TD> <TD>12274425</TD> <TD>SUPER ESTRELLA GR ACA, AR, 64X15KG BOX &nbsp;</TD> </TR> <TR> <TD>36</TD> <TD>11293612</TD> <TD>COUNTACH KOH 480, MON76567, 48X20L BT</TD> </TR> <TR> <TD>37</TD> <TD>11292224</TD> <TD>SNIPER KOH 480, MON76567, 48X20L BT</TD> </TR> <TR> <TD>38</TD> <TD>12643147</TD> <TD>SNIPER DRY, AR, 64X15KG BOX MON76934</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Table2</P> <TABLE style="border-collapse: collapse; width: 420pt;" border="0" width="560" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="80" height="20" class="xl65" style="height: 15.0pt; width: 60pt;">ID</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">DATE</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">DAY</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">MONTH</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">YEAR</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">HOUR</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">MATERIAL</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434317</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">2</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434318</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434319</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">4</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434323</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">5</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434326</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">6</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434337</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">7</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434338</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">8</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434339</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434340</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">10</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434347</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">11</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434353</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">12</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434354</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">13</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434356</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">14</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434373</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">15</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434374</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">16</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434382</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">17</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434385</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">18</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434388</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">19</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434389</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434390</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">21</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434393</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">22</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434394</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">23</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">10434395</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Fri, 15 Jul 2022 07:42:38 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956275#M11074 Luis171190 2022-07-15T07:42:38Z Re: Compare data between two tables https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956386#M11080 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/189160">@Luis171190</a>&nbsp; Not sure of your exact requirement though. But see the script below that I have used.</P> <P>NoConcatenate<BR />Temp:<BR />Load * Inline [<BR />ID MATERIAL TEXT_BRIEF_MATERIAL<BR />1 10658373 RUP ULTRAMAX,AR,64x15KG BOX<BR />2 10699860 RUP ULTRAMAX,UY, 64X15KG BOX<BR />3 10699861 RUP ULTRAMAX,BO, 64X15KG BOX<BR />4 10699862 RUP ULTRAMAX,CL, 64X15KG BOX<BR />5 10699863 RUP ULTRAMAX,PY, 64X15KG BOX<BR />6 12331311 RUP CONTROLMAX,AR,64x15KG BOX<BR />7 12386330 SUPER ESTRELLA GR 79,2 ACA, AR, 64X15KG<BR />8 12386332 SUPER ESTRELLA GR 79,2, AR, 64X15KG BOX<BR />9 10659812 RUP FG,AR,64X15KG BOX<BR />10 10699865 RUP FG,CL,64X15KG BOX<BR />11 10699867 RUP FG,PY,64X15KG BOX<BR />12 11984610 RUP FG,PY,64X15KG BOX MON76813<BR />13 11984611 RUP FG,BO,64X15KG BOX MON76813<BR />14 12383711 RUP FG L,AR,64X15KG BOX MON76934<BR />15 12806191 RUP FG,BO,64X15KG BOX MON76934<BR />16 10434287 RUP FULL II,AR,48x20L BT MON78864<BR />17 10434315 ROUNDUP FULL II,CL,48x20L BT MON78864<BR />18 10434317 ROUNDUP FULL II,PY,48x20L BT MON78864<BR />19 10434318 RUP FULL II,UY,48x20L BT MON78864<BR />20 10434319 RUP FULL II,BO,48x20L BT MON78864<BR />21 12947119 RUP FULL II,AR,48x20L BT MON301511<BR />22 10434277 HARNESS,AR,48x20L BT MON58415<BR />23 11953281 LA TIJERETA BOX, AR,64X15KG,BOX MON76813<BR />24 12870047 LA TIJERETA BOX, PY,64X15KG,BOX MON76813<BR />25 12109370 LA TIJERETA BOX, PY,64X15KG,BOX MON76813<BR />26 12383710 LA TIJERETA BOX L,AR,64X15KG,BOX MON7693<BR />27 12457272 LA TIJERETA BOX, BO, 64X15KG, MON76813<BR />28 12806192 LA TIJERETA BOX, BO, 64X15KG, MON76813<BR />29 11754119 LA TIJERETA II, AR, 48X20L BT MON 76690<BR />30 11699473 LA TIJERETA PLATINUM,MON76567,48X20L,BT<BR />31 12457273 LA TIJERETA PLATINUM, BO, MON76567<BR />32 10664941 SUPER ESTRELLA II, AR,48X20L BT MON78864<BR />33 12274427 SUPER ESTRELLA II ACA, AR, 48X20L BT<BR />34 12698505 POWER PLUS DRY, AR, 64X15KG BOX MON76934<BR />35 12274425 SUPER ESTRELLA GR ACA, AR, 64X15KG BOX <BR />36 11293612 COUNTACH KOH 480, MON76567, 48X20L BT<BR />37 11292224 SNIPER KOH 480, MON76567, 48X20L BT<BR />38 12643147 SNIPER DRY, AR, 64X15KG BOX MON76934<BR />](delimiter is '');</P> <P>Right join (Temp)<BR />Temp1:<BR />Load * inline [<BR />ID DATE DAY MONTH YEAR HOUR MATERIAL<BR />1 20220103 3 1 2022 9 10434317<BR />2 20220103 3 1 2022 9 10434318<BR />3 20220103 3 1 2022 9 10434319<BR />4 20220103 3 1 2022 9 10434323<BR />5 20220103 3 1 2022 9 10434326<BR />6 20220103 3 1 2022 9 10434337<BR />7 20220103 3 1 2022 9 10434338<BR />8 20220103 3 1 2022 9 10434339<BR />9 20220103 3 1 2022 9 10434340<BR />10 20220103 3 1 2022 9 10434347<BR />11 20220103 3 1 2022 9 10434353<BR />12 20220103 3 1 2022 9 10434354<BR />13 20220103 3 1 2022 9 10434356<BR />14 20220103 3 1 2022 9 10434373<BR />15 20220103 3 1 2022 9 10434374<BR />16 20220103 3 1 2022 9 10434382<BR />17 20220103 3 1 2022 9 10434385<BR />18 20220103 3 1 2022 9 10434388<BR />19 20220103 3 1 2022 9 10434389<BR />20 20220103 3 1 2022 9 10434390<BR />21 20220103 3 1 2022 9 10434393<BR />22 20220103 3 1 2022 9 10434394<BR />23 20220103 3 1 2022 9 10434395</P> <P>](delimiter is '');</P> <P>exit Script;</P> Fri, 15 Jul 2022 10:39:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956386#M11080 sidhiq91 2022-07-15T10:39:23Z Re: Compare data between two tables https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956387#M11081 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/189160">@Luis171190</a>&nbsp; Please ignore the above code:</P> <P>NoConcatenate<BR />Temp:<BR />Load * Inline [<BR />ID MATERIAL TEXT_BRIEF_MATERIAL<BR />1 10658373 RUP ULTRAMAX,AR,64x15KG BOX<BR />2 10699860 RUP ULTRAMAX,UY, 64X15KG BOX<BR />3 10699861 RUP ULTRAMAX,BO, 64X15KG BOX<BR />4 10699862 RUP ULTRAMAX,CL, 64X15KG BOX<BR />5 10699863 RUP ULTRAMAX,PY, 64X15KG BOX<BR />6 12331311 RUP CONTROLMAX,AR,64x15KG BOX<BR />7 12386330 SUPER ESTRELLA GR 79,2 ACA, AR, 64X15KG<BR />8 12386332 SUPER ESTRELLA GR 79,2, AR, 64X15KG BOX<BR />9 10659812 RUP FG,AR,64X15KG BOX<BR />10 10699865 RUP FG,CL,64X15KG BOX<BR />11 10699867 RUP FG,PY,64X15KG BOX<BR />12 11984610 RUP FG,PY,64X15KG BOX MON76813<BR />13 11984611 RUP FG,BO,64X15KG BOX MON76813<BR />14 12383711 RUP FG L,AR,64X15KG BOX MON76934<BR />15 12806191 RUP FG,BO,64X15KG BOX MON76934<BR />16 10434287 RUP FULL II,AR,48x20L BT MON78864<BR />17 10434315 ROUNDUP FULL II,CL,48x20L BT MON78864<BR />18 10434317 ROUNDUP FULL II,PY,48x20L BT MON78864<BR />19 10434318 RUP FULL II,UY,48x20L BT MON78864<BR />20 10434319 RUP FULL II,BO,48x20L BT MON78864<BR />21 12947119 RUP FULL II,AR,48x20L BT MON301511<BR />22 10434277 HARNESS,AR,48x20L BT MON58415<BR />23 11953281 LA TIJERETA BOX, AR,64X15KG,BOX MON76813<BR />24 12870047 LA TIJERETA BOX, PY,64X15KG,BOX MON76813<BR />25 12109370 LA TIJERETA BOX, PY,64X15KG,BOX MON76813<BR />26 12383710 LA TIJERETA BOX L,AR,64X15KG,BOX MON7693<BR />27 12457272 LA TIJERETA BOX, BO, 64X15KG, MON76813<BR />28 12806192 LA TIJERETA BOX, BO, 64X15KG, MON76813<BR />29 11754119 LA TIJERETA II, AR, 48X20L BT MON 76690<BR />30 11699473 LA TIJERETA PLATINUM,MON76567,48X20L,BT<BR />31 12457273 LA TIJERETA PLATINUM, BO, MON76567<BR />32 10664941 SUPER ESTRELLA II, AR,48X20L BT MON78864<BR />33 12274427 SUPER ESTRELLA II ACA, AR, 48X20L BT<BR />34 12698505 POWER PLUS DRY, AR, 64X15KG BOX MON76934<BR />35 12274425 SUPER ESTRELLA GR ACA, AR, 64X15KG BOX <BR />36 11293612 COUNTACH KOH 480, MON76567, 48X20L BT<BR />37 11292224 SNIPER KOH 480, MON76567, 48X20L BT<BR />38 12643147 SNIPER DRY, AR, 64X15KG BOX MON76934<BR />](delimiter is '');</P> <P>Right join (Temp)<BR />Temp1:<BR />Load * inline [<BR />D DATE DAY MONTH YEAR HOUR MATERIAL<BR />1 20220103 3 1 2022 9 10434317<BR />2 20220103 3 1 2022 9 10434318<BR />3 20220103 3 1 2022 9 10434319<BR />4 20220103 3 1 2022 9 10434323<BR />5 20220103 3 1 2022 9 10434326<BR />6 20220103 3 1 2022 9 10434337<BR />7 20220103 3 1 2022 9 10434338<BR />8 20220103 3 1 2022 9 10434339<BR />9 20220103 3 1 2022 9 10434340<BR />10 20220103 3 1 2022 9 10434347<BR />11 20220103 3 1 2022 9 10434353<BR />12 20220103 3 1 2022 9 10434354<BR />13 20220103 3 1 2022 9 10434356<BR />14 20220103 3 1 2022 9 10434373<BR />15 20220103 3 1 2022 9 10434374<BR />16 20220103 3 1 2022 9 10434382<BR />17 20220103 3 1 2022 9 10434385<BR />18 20220103 3 1 2022 9 10434388<BR />19 20220103 3 1 2022 9 10434389<BR />20 20220103 3 1 2022 9 10434390<BR />21 20220103 3 1 2022 9 10434393<BR />22 20220103 3 1 2022 9 10434394<BR />23 20220103 3 1 2022 9 10434395</P> <P>](delimiter is '');</P> <P>exit Script;</P> Fri, 15 Jul 2022 10:40:19 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956387#M11081 sidhiq91 2022-07-15T10:40:19Z Re: Compare data between two tables https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956394#M11082 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/189160">@Luis171190</a>&nbsp;,</P> <P>Can you please provide the expected output result here.</P> Fri, 15 Jul 2022 10:59:22 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956394#M11082 Iswarya_ 2022-07-15T10:59:22Z Re: Compare data between two tables https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956460#M11093 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6188">@sidhiq91</a>&nbsp;, <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/166218">@Iswarya_</a>&nbsp;, <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/29012">@Mark_Little</a>&nbsp;The expected result I need is the following. They are not continuous data from table1, they are extracted from two different Excel</P> <P>Table2</P> <TABLE style="border-collapse: collapse; width: 420pt;" border="0" width="560" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="80" height="20" class="xl65" style="height: 15.0pt; width: 60pt;">ID</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">DATE</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">DAY</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">MONTH</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">YEAR</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">HOUR</TD> <TD width="80" class="xl65" style="border-left: none; width: 60pt;">MATERIAL</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10434317</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">2</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10434318</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10434319</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">4</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12947119</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">5</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10434277</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">6</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">11953281</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">7</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12870047</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">8</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12331311</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12386330</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">10</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12386332</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">11</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10659812</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">12</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699865</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">13</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699867</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">14</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">11984610</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">15</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">11984611</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">16</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12383711</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">17</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12806191</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">18</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10434287</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">19</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10434315</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">20</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10434317</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">21</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10658373</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">22</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699860</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">23</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699861</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">24</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699862</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">25</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699863</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">26</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12386330</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">27</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">12386332</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">28</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10659812</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">29</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699865</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">30</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">20220103</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2022</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">9</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10699867</TD> </TR> </TBODY> </TABLE> Fri, 15 Jul 2022 13:01:24 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Compare-data-between-two-tables/m-p/1956460#M11093 Luis171190 2022-07-15T13:01:24Z