Since the notice for the exam schedule is out, I have seen a lot of queries around in internet requiring clarification on dates and eligibility criteria. Please refer to one authentic source for all the information: The Official Website of MPPSC.
If coding/automation is not about us fooling the machine to get our work done, we haven't yet exploited our powers enough. I, in my daily life, do all sorts of problem-solving involves complex coding, cloud computing, etc. but I get my real kick when I solve the smallest problem like hacking excel, or automation of workflow using power query. Here is my latest gig, I tried to connect to an excel in SharePoint and ensure that every time the database is updated my query picks the latest file. This is the first time I am using power query and it sounds so powerful. So without further delay, let's see what I did: 1. Connect Excel to DataBase: Open an excel file, Select Data from the green ribbon, go to Get Data , select the drop-down on From File , and connect to share point select From SharePoint Folder. Fig1: Select DataBase Once you select the database which is SharePoint in our case, you will get a window like this popping up to conn...
Comments
Post a Comment