1.0Snowflake in the Carolinashttps://snowflake.pavlik.usGreg Pavlikhttps://snowflake.pavlik.us/index.php/author/greg_nozz9ly9/Field Comparisons Using Snowflake - Snowflake in the Carolinasrich600338<blockquote class="wp-embedded-content" data-secret="wn1dMyOaDF"><a href="https://snowflake.pavlik.us/index.php/2020/01/08/field-comparisons-using-snowflake/">Field Comparisons Using Snowflake</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://snowflake.pavlik.us/index.php/2020/01/08/field-comparisons-using-snowflake/embed/#?secret=wn1dMyOaDF" width="600" height="338" title="“Field Comparisons Using Snowflake” — Snowflake in the Carolinas" data-secret="wn1dMyOaDF" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://snowflake.pavlik.us/wp-includes/js/wp-embed.min.js
/* ]]> */
</script>
Use cases for bulk field comparisons There are a lot of reasons why it may be necessary to compare the values of some but not all fields in two tables. In billing reconciliation, one table may contain raw line items, and another table may contain lines in billing statements. Another common reason would be to […]https://snowflake.pavlik.us/wp-content/uploads/2020/01/outer_join_excluding_middle.png1024721