AWS How to Use External Python Libraries in AWS Glue Job By admin Python extension modules and libraries can be used with AWS Glue ETL scripts as long as they are written in pure Python. Python libraries used in the current Job: Libraries - Pg8000 Zipping Libraries for Inclusion The libraries to be...
Databases Creating Associations with Sequelize By Gagan Manda In this blog, we will create the Models with associations and this is a continuation to the previous blog “Creating models with sequelize”. The setup process is explained in the previous blog Creating Associations is nothing but mapping the models...
Jaspersoft How to Create a user in Jasper Server using Jasper REST API in Java By Mounika This blog explains the creation of a user in jasper server using java. Java code uses REST API to create a user in the Jasper server. Make data easy with Helical Insight. Helical Insight is the world's best open source...
Jaspersoft Creating HTML 5 Charts using Multiple Datasets in Jasper By admin Prerequisite: Jasper 6.3 studio Database: Foodmart In this blog we can see how we can use 2 datasets to plot an HTML5 Bar Chart, If we need to plot a chart by using 2 values from different queries then this...
Jaspersoft Creating Report Book in Jaspersoft Studio By Ramu Vudugula Report books are multiple reports or subreports combined into a single report. It combines several sections like cover pages, table of contents, reports, subreports into a book. Make data easy with Helical Insight. Helical Insight is the world's best open...
Uncategorized Filling NA of n Columns with Nulls Based on DataType using Pandas By Sohail Lets Run through a scenario I have a csv where specific columns have nulls or Empty Values. using python pandas lets read the csv import pandas as pd t1 = pd.read_csv('E:/Blog/table3.csv',delimiter=',', encoding='iso-8859-1',low_memory=False) empid address phoneno weight comment name age 0...
Java Display Axis Label Name Fully Without Any Truncation in HTML Chart By admin Prerequisites: Jasper Server 6.4.0 Database: Foodmart In this blog we learn to display axis label name fully without any truncation Create a report to display state-wise sales using HTML line chart There are two properties that can be set depending...
Databases Creating Models Using Sequelize By Gagan Manda Sequelize is an ORM tool which is used to save data from node application to the databases like MySQL, Potgres and many other and a Model is basically a table in the database. In this blog we will go through...
Pentaho Loading Data from CSV 2.0 By Sohail Loading Data from CSV into DB in Pentaho Data Integration is very easy because the 3 things are required A Created Table Text File Input/CSV Input Component Table Output Now, what if we don't have a table created and we...
AWS AWS Glue By admin Introduction to AWS Glue AWS Glue is a cloud-optimized ETL service. It is a cloud service that prepares data for analysis through the automated extract, transform and load (ETL) processes. It helps to organize, locate, move and perform transformations on...
Jaspersoft How to Make Label Wrapping for Pie Chart in Jasper Reports By admin Prerequisites: Jasper Studio 6.4.0 Database: foodmart In this blog we will discuss how to wrapping the label text for HTML5 pie chart in Jasper reports. Make data easy with Helical Insight. Helical Insight is the world's best open source business...
Jaspersoft Passing Multi Select Values from Jasper to PostgresSQL Function By Satya Gopi Prerequisites: JasperServer Studio 6.3,Postgress DataBase:Foodmart In most of the scenario’s we will think, how we can pass a Multi-select value from Jasper to a SQL function, here is the solution for that Step 1: Created a Sample Report with a...