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
0 answers

The Characters in excel output file of spoon is not encoded properly

I have a kettle job that read data from a table and generates excel file. The header/column names are renamed to thai language using rename values. For writing excel file I use TIS-620 encoding. But in generated excel file the header field appears…
Bommu
  • 229
  • 1
  • 4
  • 14
0
votes
0 answers

Pentaho Data Integration Kettle - Why when one record is updated it appears as if two records are updated?

I am using Pentaho Data Integration Kettle and SQL Server and have already made a Data Warehouse, but there is something I don't understand. When I update a record on a dimension it appears as if two records were updated, although it only updated…
KronosL
  • 299
  • 3
  • 4
  • 11
0
votes
0 answers

How to partially normalize a table?

Let's say I have the table: M1 M2 M3 S1 S2 S1 S2 S1 S2 P1 D1 T1 0 1 2 3 4 5 P2 D2 T2 6 7 8 9 10 11 P3 D3 T3 12 13 14 15 16 17 The XML Input:
Nae
  • 14,209
  • 7
  • 52
  • 79
0
votes
1 answer

Pentaho File Repository Moves Jobs & Transformations to root

I created a new file repository, and then moved my pentaho project files into the root folder using a file manager. I then connected to my file repository and opened(Ctrl-O) my job & transformation files(in a folder/), then tried to run them, which…
Nae
  • 14,209
  • 7
  • 52
  • 79
0
votes
1 answer

Pentaho Dummy set not passing data

I am trying to use a Dummy set in latest version of Pentaho to UNION two streams. When I do that the next step always says "unable top find rowset" Am I forgetting something?
ed4becky
  • 1,488
  • 1
  • 17
  • 54
0
votes
3 answers

Error while saving transformation in pentaho spoon

I am getting below error while I save the transformation in pentaho spoon: Error saving transformation to repository! Error updating batch Cannot insert duplicate key row in object 'dbo.R_STEP_ATTRIBUTE' with unique index 'IDX_RSAT'. The duplicate…
Bommu
  • 229
  • 1
  • 4
  • 14
0
votes
1 answer

Kettle Spoon fails find column with Database value lookup

I'm using Kettle Spoon 7.1.0.0.12 from a while but now I'm experiencing a very weird problem. I'm using Database Value lookup on a table in my Mysql db. The table field name I'm checking in "account_id" and I'm absolutely sure this column is on the…
drenda
  • 5,846
  • 11
  • 68
  • 141
0
votes
1 answer

spoon - merge two CSV using an ID

I have two CSV, the first is like: ID, name, surname ABC//001, John, Doe the second is like: ID, mail, phone 001, john@doe.com, 001 001001 The problem is the ID, in the first file there is a string before the actual ID. I tried with merge Join but…
Alfox
  • 79
  • 1
  • 9
0
votes
0 answers

Janino generics issue in PDI

I'm trying to code something in PDI which uses Janino for compilation. This code Element firstRow = doc.select("tr").first(); Elements headers = firstRow.select("td"); List list = headers.eachText​(); throws and error A method named "eachText​" is…
PalePal
  • 53
  • 1
  • 4
0
votes
3 answers

Sybase connection is idle for a long time

I'm reading data from a table in Sybase using a Table Input step. The query is really simple: SELECT person_ref, displayname FROM person That table has about 2 million rows. I'm connecting to Sybase ASE 12. My user has read-only rights. PDI is…
Carlos Hurtado
  • 68
  • 6
0
votes
3 answers

Merge Join Pentaho Issue

I've got this question: I've got two sources in A and B and a Merge Join Step (in INNER option). the image shows what I am facing. I am getting the right identifiers but with the value of the lastest row repeted n times for each one of them. I…
d2907
  • 798
  • 3
  • 15
  • 45
0
votes
2 answers

Execute row SQL script can't read .sql file. I am getting this error

2018/02/01 11:20:00 - Execute row SQL script.0 - We can not find field [C:\Users\abc\Documents\xyz\query\record.sql] in input stream! My steps involve - get variables - input Execute row SQL script - where I am trying to read my query file text…
P.C
  • 24
  • 6
0
votes
1 answer

can we use "prompt" function of javascript in pentaho?

can we use "prompt" function of javascript in pentaho? I am getting this error JavaScript - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Couldn't compile javascript: org.mozilla.javascript.EcmaError:…
P.C
  • 24
  • 6
0
votes
1 answer

Pentaho Geokettle: Convert Epoch time to human time

I am currently working with Pentaho GeoKettle (or Spoon) and I am trying to import data into a database from a csv file. In the csv-file, there is a column which holds a timestamp in Epoch-format. But I have to import it to the database in the human…
user7335295
  • 401
  • 2
  • 7
  • 31
0
votes
1 answer

how to connect multiple input table to fact table in pentaho

It would be helpful for me if somebody can tell me how to connect the multiple input tables in pentaho to one fact table? Pentaho table inputs
Nivedita C
  • 1
  • 2
1 2 3
…
55 56