Tutorial by Examples: u

By selecting a matrix and choosing "Insert Table" from the menu, you create a table which allows you to pull and insert data in a structured way. Let's say you have named the table "SalesEvents" and given that the first (header) row reads "Salesperson" "Date" ...

When you have an Excel Table, and not only then, it is easy to use data as input in a PivotTable which will provide most of the analysis you would need on it. Learn to use it you won't regret it! It could replaces tons of user designed cell Formulas and it is fast and much easier to document.

Sometimes it is hard to make all the data of your Pivot Table confirm to the reporting format you have to present your crunched data into. Then use GetPivotData! It has an automatic fill in of arguments that you easy can learn from and it lets you through its parameters flexibly choose and pick from...

[MetadataType(typeof(RoleMetaData))] public partial class ROLE { } public class RoleMetaData { [Display(Name = "Role")] public string ROLE_DESCRIPTION { get; set; } [Display(Name = "Username")] public string ROLE_USERNAME { get; set; } } If you us...

In this example there are 2 instances created of the SomeClass Class. Depending on the type given the 2 instances have a different interface: Dim theStringClass As New SomeClass(Of String) Dim theIntegerClass As New SomeClass(Of Integer) The most famous generic class is List(of )

With this line we will install all the necessary packages in one step, and the last update: pacman -Syu apache php php-apache mariadb HTTP Edit /etc/httpd/conf/httpd.conf Change ServerAdmin [email protected] as you need. The folder of the WEB Pages by default is ServerRoot "/etc/httpd&q...

Gui, Add, Text,, Hello World! Gui, Show, w200 h200 return GuiClose: ExitApp

mock-data.ts Create the mock api data export class MockData { createDb() { let mock = [ { id: '1', name: 'Object A' }, { id: '2', name: 'Object B' }, { id: '3', name: 'Object C' }, { id: '4', name: 'Object D' } ]; return {mock}; } } main.t...

mock-data.ts export class MockData { createDb() { let mock = [ { id: '1', name: 'Object A' }, { id: '2', name: 'Object B' }, { id: '3', name: 'Object C' } ]; let data = [ { id: '1', name: 'Data A' }, ...

Joins can also be used in a DELETE statement. Given a schema as follows: CREATE TABLE Users ( UserId int NOT NULL, AccountId int NOT NULL, RealName nvarchar(200) NOT NULL ) CREATE TABLE Preferences ( UserId int NOT NULL, SomeSetting bit NOT NULL ) We can delete rows...

.populate() in Mongoose allows you to populate a reference you have in your current collection or document with the information from that collection. The previous may sound confusing but I think an example will help clear up any confusion. The following code creates two collections, User and Post: ...

Django is a full stack framework for web development. It powers some of the most popular websites on the Internet. To install the framework; use the pip tool: pip install django If you are installing this on OSX or Linux, the above command may result in a permission error; to avoid this error, ...

In django, there is a url mapper which maps URLs to specific functions (views) which return responses. This strict separation between the file system layout and the URL layout allows great flexibility when writing applications. All url patterns are stored in one or more urls.py files, and there is ...

ASP.NET Core provides the status code pages middleware, that supports several different extension methods, but we are interesting in UseStatusCodePages and UseStatusCodePagesWithRedirects: UseStatusCodePages adds a StatusCodePages middleware with the given options that checks for responses with...

<a data-bind="attr: { href: myUrl }">link with dynamic href</a> ko.applyBindings({ myUrl: ko.observable("http://www.stackoverflow.com") }); Since there is no native href binding in KnockoutJS, you need to use a different feature to get dynamic links. The abo...

href binding is not native to KnockoutJS, so to get dynamic links use a custom binding handler: <a data-bind="href: myUrl">link with dynamic href</a> ko.bindingHandlers['href'] = { update: function(element, valueAccessor) { element.href = ko.utils.unwrapObservable(v...

/* SD card file dump This example shows how to read a file from the SD card using the SD library and send it over the serial port. The circuit: * SD card attached to SPI bus as follows: ** MOSI - pin 11 ** MISO - pin 12 ** CLK - pin 13 ** CS - pin 4 created 22 December 20...

> library(ggplot2) > ggplot(iris,aes(Sepal.Width)) + geom_density() + xlim(1,3.5) Using xlim or ylim the plot is not cutted, ggplot subsets the data before calling the stat function (stat_density in this case). You can see it in the warning message. Warning message: Removed 19 rows cont...

ggplot(iris[iris$Species == "setosa",],aes(Sepal.Width)) + geom_density() Here, we are subsetting the dataframe before passing it to ggplot. It is a very useful tool derived from the data frame data structure. To make the code more readable, one can also use dplyr's filter: libr...

This example shows how to find circular blobs in an grayscale image. The evaluation of the circularity of a blob is done using the area and the perimeter (arc length) of the contour. The center point gets evaluated using the moments of the contour. #include "opencv/cv.h" #include &quot...