I want to extract certain set of rows(lets say rows 10-30) from same sheet(lets say sheet "income statement") present in multiple excel files to create a data dump in an automated manner. Also i want to shape the data in a particular way ( basically pivoting and transposing on certain columns). I want to use powerquery (and probably M, if required) for this.
...underlying report logic from the SAP GUI (using SE93). I need you to replicate exactly the code that is represented by the SAP Report as an end product being a standard SQL query. I have direct access to the underlying tables through an ODBC connection, and therefore need to have SQL queries constructed that replicate exactly the logic built into those
Hi, I need some SQL query line work outsourced for my company. Must be done right away.
===> Should have expert knowledge in Oracle table partitioning and performance tuning NOTE: Confidential -------------------------------- For purging sub-partitions, we shall have purge profiles. We have around 2000 bank's... should be distributed among the purge profiles... purge profile 30 days... 60 days... 90 days... we shall have column retprofile
I received an email that has HTML table within it with inline stylings etc. The table is in the screenshot. I need this converted to bootstrap responsive theme, and styling moved to a separate css file. Bid only if you can do it. You will have to write it from scratch based on the screenshots I give you. The one now attached is just an example, there's
1 step : need help creating ajax query to send and receive json data with multiple data 2nd step : need help to create php script that receive data send using ajax query and call another php script 3rd step : call another php script to perform specific function from another folder 4th stpe: send output back to web page 5th step : need to make sure
...io/[login to view URL] downloadable here [login to view URL] . How the counter should run: Every member who wants to join is entered in a mysql table. After that (entry date), he will be displayed with the others on webpage. Imagine the demo above, every square is a member (next to all others). The square shows photo
...(including folders). I have tried to pass this to a JSP page, so I can print the fileList in a HTML table using bootstrap. However, I am having no luck. The following files are what I have so far. I may also want to also add the size of each file in the table too but will discuss that further once this first part is done. I don't use an IDE, I use Jedit
Hello, I run a Wordpress store with Woocommerce. I want to display a top 10 sales charts of "recent" sales on a page. I'm looking for a custom script / query to display a vertical list of the 10 products that sold the most copies in the last 30 days (like a current top sales charts). I would like to have it usable via a shortcode, so that I can display
I have Insert Sql procedure in SQL Database. I want to map this sql store procedure in Entity Frame Work Table Mapping with Insert Function. Problem here is procedure is having three output parameter which should get mapped in Table Mapping of EF. Please also write small function where [login to view URL]() is called and function is able to receive the
...need a SQL query that will return a set of frequently used patterns / word combinations in a field, as well as the number of matches found for that pattern in the field. Any amount of text could exist before or after the pattern that's shown. I should be able to add Where clauses to the query to filter the dataset that's used for the query. Example:
Looking for someone to do more jobs with.
data table design, I am looking for a designer, for data table, I need a better look and clear. html It is not much work and can be completed in 1 - 2 days. only serious offers, thank you very much
...used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs whatever i do. table wont let me add a new row.. wont accept any varchar. it only admits text.. i have 230 rows in table.. and need to add 100 more... i attched the table. you
PHP script to migrate a view from microsoft sql server to a MySQL table. Attached sql view structure.
BIDS OVER $100 WON'T BE HIRED. VIDEO INSTRUCTIONS = [login to view URL]
I am looking for googlesheets integration with the eventbrite api. I would like to be able to run a query like this: [login to view URL] and have the results returned into a googlesheet with each event
I uploaded a chart that shows X / Y and I need to change the percentages and make them accurate. The seller is offering a cash certificate and he is giving out 30% discount ( $15 on $50) BUT the 30% is ONLY on the first $50 spent!!! So if the buyer spends $100 the money spent above $50 is NOT Discounted so the REAL or EFFECTIVE discount the seller is really giving out is only 15%. ( $15 on $1...
I need a Woocomerce expert to quickly show me how to make a particular woocomerce table responsive on the order-pay page. This works fine on desktop devices, but the table is not responsive on mobile devices which is quite disturbing. I need this done immediately. Please note that you will have to tell me the fix or log in remotely to my computer
Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
I'm looking to build a drawing for a table with an articulating arm. Need to have a patent drawing too.
Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
hello I'm looking for a developer that can do a crud java script and firebase, Basically it's save, names, surnames, phone, upload your profile image and upload another 5 alternative images to firebase storage
Need someone with a trailer or lorry to pickup a table tennis table from High Wycombe, Buckinghamshire and deliver to Wheatley.
Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
need to find out how to view sql query history that shows who ran the query, how many records affected, where it was run from etc..
I need some changes to an existing website. I already have a design, I just need you to build it. I would like a query display on a page that shows current unpaid customers.
I need an small simple excel spread sheet that can show numbers for the below: Assuming a 4 week month. 2 people per week are signed up to a care plan, the care plan is for 12 visits and is broken down as 2visits per week and then 1 visit per week. is it possible to provide an excel spread sheet showing the number of visits per week over 1 year. I also need to be able to change the number of p...
I need a javascript expert to design a table with css for the xml already getting extracted. I shall provide the details to the right person .
I need a query to activate "Status Stock" In stock on all my products Type: Configurable Product Issue: There was a load of products but the Options Status Stock is Out Of Stock and it display the products on the front "Out Of Stock" even when the variables has stock on it.
just wanna move my single bed mattress and side table 4kms from one home to another asap today.
I am looking for someone who ca...makes suggestions based on values of a column in a table. - the values for the drop downs will also be from a column in a database table. Once the form is created, it will need to work as a search "system" to query a table in the database and display a table with the returned values. Using AJAX, PHP, JavaScript...
...[login to view URL] mysql-results-set-in-php-using-jquery-and-a-more-traditional-approach I tried the Table Sorter wp plugin, but it does not work because it interprets the code that generates the table as having only one line, but the number of rows depends by the sql query and table. You can see the code that currently generates
In a wordpress site I have a table based on 3 queries (see the attached file for the table code). I'm using a plugin to make it sortable and it works, but I'd like it to have already an automatic initial (default) sorting. The wp plugin (Table Sorter) already provides this possibility (class=tablesorter {sortlist: [[1,0],[2,0],[3,0]]}) but it is not
API Using the [login to view URL] POST /rest/catalog/productsstockbyreference We need to generate a simple XML based on multiple SKU query. This will then be imported into WordPress daily. This is a temporary measure until a full connector has been built by our third party.
In ...site I have a table based on 3 queries (see the attached file for the table code). I'm using a plugin to make it sortable and it works, but I'd like it to have already an automatic initial sorting since loading. The plugin already provides this possibility (class=tablesorter {sortlist: [[1,0],[2,0]]}) but it is not compatible with my table code.
hello i decided to make table game portal. at this moment i am searching for programer who can write ex. dominoe game engine that can calculate the ideal move and oponents hand. computer should calculate the attacking strategy (collect as much points as possible) and defensive strategy (oponent not to collect points). main thing is that computer should
I need assisted with Power Query. I have a project to create a Query that will allow me to pull data from Q1 and Q2 and print quarterly reports.
...to design a table for us which lists the names of books and magazines on a tablet for a book-keeper. We actually had some previous designs made by a designer. However, at that time, the design was "static." Of course now that we have a coded table already, the table is not static anymore as entries are placed in it, and thus the table is dynamic and
***********************************READ THIS FIRST**************************************** INDIVIDUAL PROGRAMMERS ONLY - WE DO NOT WANT YOUR TEAMS, YOUR COMPANIES, YOUR FIRMS, YOUR SUBCONTRACTORS OR YOUR FRIENDS/PARTNERS. IF YOU CAN NOT COMPLETE OUR PROJECTS YOURSELF - DO NOT APPLY - DO NOT MSG ========================================================================= About the Application and Sk...
It's a project for Lian as agreed. Thanks
...where we would like to add a [login to view URL] table. It should be a small job for someone compentent in [login to view URL] and BootstrapVue. The reason we are adding it to Freelanser is lack of knowledge and time constraints. The attached file "Example table layout and output from exmple [login to view URL]" shows the desired table layout. The functionality ...
Need to batch process some images to add a one sided border and fill the border with some data from a table. More Details in attachment. Although this is a small one-time project, if you can do this, I have several similar requirements.
We're looking for a professional proofreader to read our book with a page count of 500 pages. The book includes recipes and editorial, also fact-checking that the addresses are correct for each venue. I need to see that you have at least 5 years experience of proofreading and have proofread books before. We have internal style guides to work off. Turnaround time is by Tuesday 18th Septemb...
The problem is that part of the query is passed from another file. I think it will be easy to fix
I need someone who can write me a Query for PHP/MYsql to update 2 tables, I have about 5 warnings in error_log file after upgrade to PHP7.2: count(): Parameter must be an array or an object that implements Countable (2x) Illegal string offset 'content' (: eval()'d code) array_key_exists() expects parameter 2 to be array, null given count(): Parameter
A football club wish to take table data from an asp.net website (link below) [login to view URL] they wish to fetch the table data on this website and then make it show on a page or a sidebar on a wordpress website (link below) [login to view URL] Please see attached images 1 and 2 and note that there
I need Android Application For my restaurant which will be book the table online and send notification to user.
