https://community.fabric.microsoft.com/t5/Developer/Merging-dynamically-a-column-with-a-static-table/m-p/1513738#M26581 <P>Hello Everyone!</P><P>&nbsp;</P><P>I have a daily growing database that looks like this:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="anaescobararias_0-1606220604057.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/403552iE8F2393E821213AA/image-size/medium?v=v2&amp;px=400" role="button" title="anaescobararias_0-1606220604057.png" alt="anaescobararias_0-1606220604057.png" /></span></P><P>Every day a new column is added containing the cumulative data up to that day. I am looking for ways to take the column matching today() and merge it to a static table using the country.</P><P>&nbsp;</P><P>Any ideas on how to do this?</P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P> Tue, 24 Nov 2020 12:25:37 GMT Anonymous 2020-11-24T12:25:37Z https://community.fabric.microsoft.com/t5/Developer/Merging-dynamically-a-column-with-a-static-table/m-p/1513738#M26581 <P>Hello Everyone!</P><P>&nbsp;</P><P>I have a daily growing database that looks like this:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="anaescobararias_0-1606220604057.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/403552iE8F2393E821213AA/image-size/medium?v=v2&amp;px=400" role="button" title="anaescobararias_0-1606220604057.png" alt="anaescobararias_0-1606220604057.png" /></span></P><P>Every day a new column is added containing the cumulative data up to that day. I am looking for ways to take the column matching today() and merge it to a static table using the country.</P><P>&nbsp;</P><P>Any ideas on how to do this?</P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P> Tue, 24 Nov 2020 12:25:37 GMT https://community.fabric.microsoft.com/t5/Developer/Merging-dynamically-a-column-with-a-static-table/m-p/1513738#M26581 Anonymous 2020-11-24T12:25:37Z