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
1 answer

How to get Error Description when Handling it at Pentaho Data Integration

How to get the description of exception when you handling an error, for example if the data type of a field is incompatible PDI throws you offending row by any reason. And so how to get the explanation?
kelgwiin
  • 766
  • 1
  • 12
  • 23
0
votes
1 answer

How to Get Data from CSV File and Send them to Excel Using Pentaho?

I have a tabular csv file that has seven columns and containing the following data: ID,Gender,PatientPrefix,PatientFirstName,PatientLastName,PatientSuffix,PatientPrefName 2 ,M ,Mr ,Lawrence ,Harry , …
MEhsan
  • 2,184
  • 9
  • 27
  • 41
0
votes
1 answer

Kettle: collector for rows with different metadata

In Kettle I have two steps with different meta layout that send data to a common User Defined Java Class that acts as data collector (see the following picture for reference). The output rows sent by the to steps have different metadata. However,…
Claudio
  • 10,614
  • 4
  • 31
  • 71
0
votes
0 answers

Creating trigger file using pentaho kettle

I have a log table where it captures log each and every time the main table is loaded, and what i need is that i need to create a trigger file using pentaho kettle each and every time the log table gets updated. And the log table is in teradata. Any…
Lavanya D.
  • 491
  • 2
  • 6
  • 15
0
votes
1 answer

Simple Evaluation to run a step once a week only?

I want to run a Job that, if it is the first time running the Job this week, it will go trough an extra step. I found that I can do this evalution with Simple Evaluation but I can't find how to make this 'once a week'check. Anyone have any idea how…
Vinícius Affonso
  • 85
  • 10
0
votes
1 answer

Pentaho Spoon Job Executes Fine, Endless Loop in Kitchen

Without getting too much into the weeds, I have a Pentaho PDI job with multiple sub-transformations and sub-jobs (ETL from MySQL to Postgres). This job runs exactly as expected from Spoon, no errors, but when I run the job--with the following…
user1983682
  • 208
  • 6
  • 20
0
votes
1 answer

Spoon ETL how to change the values

I want to transform two values in a column with spoon. I have a value "1" in the column gender and want to change this to the value "Male" And I have a value "0" in the column gender and want to change this to the value "Female" As you could see the…
user5659169
0
votes
1 answer

How to work with Pentaho's HTTP Post step and Spark Java

I'm trying to create a Kettle transformation to populate my Spark Java (sparkjava.com) server,deployed on heroku, instead of inserting the data by hand. The code on the server side to take care of a Post request on the route "/insert" is the…
PedroCunha_67677
  • 49
  • 1
  • 8
0
votes
2 answers

How can i merge header cells in Excel writer in pentaho?

I am trying to merge header cells columns into one cell but when i do that my data also comes in one column. I want my resulting output as per this screenshot attached. Kindly help me for this.
Sachin Mittal
  • 21
  • 1
  • 3
0
votes
1 answer

Retrieve results from a batch of SQL queries in Pentaho or Postgres?

I'm still relatively new to SQL and Pentaho. I've pulled a table with two different IDs and need to run a query for each specific instance. For example, SELECT * FROM Table WHERE RecordA = 'value in column A' AND RecordB =…
S J
  • 1
  • 1
0
votes
1 answer

Google Conversion tracking Pentaho

I am into a different situation here, I have been working with google analytic in pentaho, to fetch aggregate values on the dashboard, but now the situation is different, company want to see if an order was converted, what were the keywords that the…
shzyincu
  • 409
  • 4
  • 21
0
votes
4 answers

Converting date yyyy-mm-dd to dd/mm/yyyy format in pentaho and store in a database

There is a column where values are in dd/mm/yyyy format and at some places there exists a date which are in format of yyyy-mm-dd, when I try to store this in a database table it gives me an error, while creating this table I had mentioned the…
Deepesh
  • 820
  • 1
  • 14
  • 32
0
votes
1 answer

Pentaho 6.0.1 connection to Mapr 5.0.1

I am trying to connect Pentaho DI to Mapr. While creating a connection I get the following error Unable to load the {0}Shim. I am using Pentaho Enterprise edition. Has anyone faced similar issue. Thanks
Pawan Sharma
  • 41
  • 4
0
votes
2 answers

Pentaho Kettle Spoon Error During CSV to mySQL error

I am trying to update and/or insert records that need to be updated in a mySQL database. I am trying to use spoon by pentaho. I am using the update transformation. I keep getting an error during import that I just cannot figure out what is…
Harry Spinely
  • 1
  • 1
  • 1
0
votes
1 answer

pentaho mysql datetime javascript comparison

Hi Guys! I am having an issue, while comparing MySQL date time with format using javascript, for an example: 2016-01-25 01:22:00 i load it and trying to compare it with in the JavaScript scope, but its not working, am using "Modified Java Script…
shzyincu
  • 409
  • 4
  • 21
1 2 3
…
55 56