{"id":542,"date":"2014-09-13T09:38:49","date_gmt":"2014-09-13T09:38:49","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=542"},"modified":"2015-06-18T06:44:26","modified_gmt":"2015-06-18T06:44:26","slug":"excel-aggregate-operations","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/excel-aggregate-operations\/","title":{"rendered":"Excel Aggregate Operations"},"content":{"rendered":"<pre class=\"brush: xml; title: ; notranslate\" title=\"\">\r\n =CONCATENATE(B2,&quot;.&quot;,C2,&quot;.&quot;,D2)\r\n\r\n--Update Script\r\n  =CONCATENATE(&quot;UPDATE Location SET Location_Description = '&quot;, D2, &quot;'  WHERE  LOCATION_CODE ='&quot;, B2,&quot;' AND LOCATION_NAME ='&quot;, C2, &quot;'&quot;)\r\n<\/pre>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n UPDATE Location \r\n   SET Location_Description = 'Thats where I Live'\r\n WHERE LOCATION_CODE = '600018'\r\n   AND LOCATION_NAME = 'Teynampet'\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>=CONCATENATE(B2,&quot;.&quot;,C2,&quot;.&quot;,D2) &#8211;Update Script =CONCATENATE(&quot;UPDATE Location SET Location_Description = &#8216;&quot;, D2, &quot;&#8217; WHERE LOCATION_CODE =&#8217;&quot;, B2,&quot;&#8217; AND LOCATION_NAME =&#8217;&quot;, C2, &quot;&#8217;&quot;) UPDATE Location SET Location_Description = &#8216;Thats where I Live&#8217; WHERE LOCATION_CODE = &#8216;600018&#8217; AND LOCATION_NAME = &#8216;Teynampet&#8217;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76],"tags":[],"class_list":["post-542","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=542"}],"version-history":[{"count":3,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/542\/revisions"}],"predecessor-version":[{"id":919,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/542\/revisions\/919"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}