powerpivot - Excel: automatically replicate number of lines -


i have huge table1 many columns. need bring on information table2 which:

  1. only has 10 columns
  2. values in these columns calculated (e.g. if/then, index/match, etc)
  3. currently "=table1[xxx]" , incorporate in needed formula, i.e. table2 has exact number of rows table1.

problem: data in table1 refreshed weekly, i.e. new lines appear. how can make table2 automatically take number of lines/entries table1 has? made table2 2 times longer, results in value errors prevents me using pivot tables. think solution can done using powerpivot connections i'm stuck regards how it.


Comments

Post a Comment

Popular posts from this blog

javascript - Knockout pushing observable and computed data to an observable array -

i trying push multiple data (firstname , lastname), along when compute firstname , lastname , try push data in same array thrown error. below code. viewmodel: var viewmodel = function () { var self = this; self.gameofthrones = ko.observablearray ([ {firstname: 'jon', lastname: 'snow'}, {firstname: 'robb', lastname: 'stark'} ]); self.firstname = ko.observable(''); self.lastname = ko.observable(''); (var i=0; i<self.gameofthrones().length; i++) { self.gameofthrones()[i].fullname = ko.computed (function () { return self.gameofthrones()[i].firstname+" "+self.gameofthrones()[i].lastname; }) }; $('#classic').click( function() { self.gameofthrones.push( {firstname: $('#fn').val(), lastname: $('#pr').val()} ); }); } ko.applybindings(new viewmodel()); html view: <form class="" action="index.html" method="post"...
Read more

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

sitecore - Resolve ISitecoreService using SimpleInjector -

isitecoreservice accepts database name string parameter in constructor (web or master) isitecoreservice service = new sitecoreservice("master"); //or isitecoreservice service = new sitecoreservice("web"); is possible dynamically send database name parameter ioc , resolve it? example send web/master string parameter , new instance of isitecoreservice like this? container.register<isitecoreservice>(() => new sitecoreservice("master"));
Read more