Stack Overflow
Stack Overflow

Questions tagged [pentaho-spoon]

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Documentation: http://wiki.pentaho.com/display/EAI/Spoon%2BUser%2BGuide

828 questions
0
votes
2 answers

Kettle (spoon) - get filename for excel output from field in the excel field in input

I'm trying to process an excel , I need to generate una excel file for each row and as filename I need to use one of the fields in the row. The excel output hasn't the option "Accept filename from field" and I can't figure out how to achieve…
Miquel Àngel
  • 149
  • 1
  • 3
  • 11
0
votes
1 answer

Regular expressions string replacement

I need a little help with regular expressions. I need to locate a string: {"users":[ and replace it with {"name": "blaaaa", "users":[ In a complex json file. I am completely ignorant about regexes. Thank you
Srdjan Nikitovic
  • 853
  • 2
  • 9
  • 19
0
votes
1 answer

Pentaho 6 Spoon Error

I use Pentaho 6 (6.0.1.0-386). My system is Ubuntu 14.04 LTS Linux LT0124 3.13.0-95-generic #142-Ubuntu SMP Fri Aug 12 17:00:09 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux Java version: java version "1.8.0_101" Java(TM) SE Runtime Environment (build…
wlodi83
  • 123
  • 1
  • 13
0
votes
0 answers

Pentaho Kettle (Spoon) - Delete Records

I'm trying to delete records in my target table based on whether the records exists in the source table. I tried using the 'Delete' step but then realized that this step is based on a conditional clause. My condition is quite simple "if the…
WRKM
  • 1
  • 3
0
votes
3 answers

Finding index using switch case statement in javascript

I'm using Pentaho(ETL) tool to achieve the output using a javascript component which accepts javascript code to achieve the desired transformation.The following table is imported into pentaho from a .csv file(source file). For example this is my…
Deepesh
  • 820
  • 1
  • 14
  • 32
0
votes
0 answers

Pentaho DI Sqlite.db in job not showing transformation changes

1) Pentaho/Spoon DI job unzips files & creates sqlite.db file with all those files converted to tables.( used Shell) 2)Couple of tables are to be added to the Sqlite.db from Mysql db using queries.( used table i/p o/p) 2) is a transformation that…
Hem
  • 130
  • 2
  • 12
0
votes
1 answer

Pentaho DI - How to use "all" results from prior step in the next step as an "IN" query

I have input from a tableA in database A that I would like to join to another tableB in database B. These were my two options: Use Database Join: For each input from table in database A, run the join query in database B. Use two Input tables…
SRS
  • 15
  • 1
  • 6
0
votes
0 answers

Transposing the data in order to get the max value from column in pentaho

With the reference to my previous question Fetching the max value from ROWS in pentaho I'm trying to transpose the rows to column using row-denormaliser but i;m not able to get the desired result, any method will do(the ultimate aim is to get the…
Deepesh
  • 820
  • 1
  • 14
  • 32
0
votes
1 answer

Spoon connectivity issue to PostgreSql

Error message is thrown while connecting to database from Spoon. Selected the View option that appears in the upper-left corner of the screen, right-clicked on the Database connections option, and selected New. Under Connection Type, selected the…
Dex
  • 388
  • 5
  • 31
0
votes
2 answers

Fetching the max value from ROWS in pentaho

I have a table structure ID Col_1 col_2 col_3 col_4 1 34 23 45 32 2 20 19 67 18 3 40 10 76 86 I here want the max value from col_1,col_,col_3,col_4 so my output looks like ID Col_1 col_2 col_3…
Deepesh
  • 820
  • 1
  • 14
  • 32
0
votes
1 answer

Scheduled sequential jobs in Ubuntu server

I want to write two scheduled jobs for my Ubuntu 14.04.4 server. The jobs need to be sequential. The first job should unzip a .gz file (SQL Dump) and then import the table "myTable" into MySQL Database (localhost). The second job (written using…
Danish Bin Sofwan
  • 476
  • 1
  • 6
  • 21
0
votes
0 answers

MySQL Database Connection in Pentaho

I am trying to create a new connection in pentaho to connect mysql database. And I am getting an below error. Pentaho community edition V6.1 Connector : mysql-connector-java-5.1.17-bin.jar Error connecting to database [Reports] :…
Naveen Kumar
  • 582
  • 2
  • 8
  • 25
0
votes
1 answer

Inserts blocking other tables

We are inserting rows in a PostgreSQL database using 1000 rows transaction/commits on a Pentaho-spoon transformation. The table has several fields/constraints as foreign keys, i.e. customer_id must exist on customer table and similars. From time to…
DeepButi
  • 402
  • 4
  • 19
0
votes
2 answers

Concat from Data Grid with Spoon

I have a problem using the javascript step transformation. I have only three steps: 1- Data Grid (with the dataset) Input: Col_1 | Col_2 | Col_3 a b c d e f 2- Modified Java Script Value var resultField = col1 + " " +…
Idir Ouhab Meskine
  • 587
  • 1
  • 9
  • 23
0
votes
2 answers

Occasional "Premature end of file" error while running RSS Input in kettle?

In pentaho kettle, I configured the RSS Input step with some URLs. When I run the transformation, it runs perfect most of the times but sometimes, it shows the following error: 2016/06/29 13:10:48 - RSS Input.0 - ERROR (version 6.0.1.0-386, build 1…
psr
  • 2,619
  • 4
  • 32
  • 57
1 2 3
…
55 56