Skip to content

Instantly share code, notes, and snippets.

View rishuatgithub's full-sized avatar
🏠
Working from home

Rishu Shrivastava rishuatgithub

🏠
Working from home
View GitHub Profile
@rishuatgithub
rishuatgithub / FillNullRowsUsingJavaScript.ktr
Last active September 21, 2023 22:13
Pentaho - Fill Null Rows using JavaScript
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>FillNullRowsUsingJavaScript</name>
<description>Fill Null Rows using JavaScript in Pentaho</description>
<extended_description>@Author: Rishu Shrivastava</extended_description>
<trans_version>1</trans_version>
<trans_type>Normal</trans_type>
<trans_status>1</trans_status>
<directory>/</directory>
@rishuatgithub
rishuatgithub / SimplePDFTableExtraction
Created July 6, 2019 12:53
Extract Tables From PDF
package com.rks.git.pdf.parser.build;
import java.io.File;
import java.io.IOException;
import java.util.List;
import org.apache.pdfbox.pdmodel.PDDocument;
import technology.tabula.ObjectExtractor;
import technology.tabula.Page;
import technology.tabula.RectangularTextContainer;
@rishuatgithub
rishuatgithub / JSONNestedBuild.ktr
Created July 18, 2018 21:08
This gist explains to create nested JSON structure in Pentaho DI
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>JSONNestedBuild</name>
<description>Building Nested Logic of a flattened Data - By Rishu Shrivastava</description>
<extended_description>v1.0 INITIAL VERSION 19.07.2018</extended_description>
<trans_version>1.0</trans_version>
<trans_type>Normal</trans_type>
<trans_status>1</trans_status>
<directory>/</directory>
@rishuatgithub
rishuatgithub / MarkLogicRESTApi.ktr
Created July 15, 2017 13:05
MarkLogic Using REST API - Pentaho Kettle
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>MarkLogicRESTApi</name>
<description>Connecting to Mark Logic Database using Pentaho Kettle - By Rishu Shrivastava</description>
<extended_description>version 1.0: Initial version</extended_description>
<trans_version>1.0</trans_version>
<trans_type>Normal</trans_type>
<trans_status>1</trans_status>
<directory>/</directory>
@rishuatgithub
rishuatgithub / ReadingChildXMLData.ktr
Last active October 5, 2015 07:40
ReadingXMLChildNodes
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>ReadingChildXMLData</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<directory>&#x2f;</directory>
<parameters>
@rishuatgithub
rishuatgithub / T_TransformDate.ktr
Created July 22, 2015 14:09
Auto changing new columns
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>T_TransformDate</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<directory>&#x2f;</directory>
<parameters>
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>T_PartitionDemoMaster</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<trans_status>0</trans_status>
<directory>&#x2f;</directory>
@rishuatgithub
rishuatgithub / T_ReturnMissingValues
Created May 15, 2015 12:10
T_ReturnMissingValues
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>T_ReturnMissingValues</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<directory>&#x2f;</directory>
<parameters>
@rishuatgithub
rishuatgithub / T_KettleReverseGroupConcat
Created April 14, 2015 11:28
Reverse Group Concat using PDI and Split Fields
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>T_KettleReverseGroupConcat</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<directory>&#47;</directory>
<parameters>
@rishuatgithub
rishuatgithub / J_MultipleSQLintoTable_MasterJob.kjb
Created February 27, 2015 20:23
kjb file to read multiple sql into a target one by one
<?xml version="1.0" encoding="UTF-8"?>
<job>
<name>J_MultipleSQLintoTable_MasterJob</name>
<description/>
<extended_description/>
<job_version/>
<job_status>0</job_status>
<directory>&#x2f;</directory>
<created_user>-</created_user>
<created_date>2015&#x2f;02&#x2f;28 01&#x3a;19&#x3a;21.727</created_date>