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

Improving the Speed of Filter Rows in Pentaho

I am trying to filter out records from an excel sheet with over 94000 records with a simple validation and getting them in a new Excel sheet using Pentaho . But the speed of reading the input file and filtering of the record reduces gradually to…
Enthusiastic
  • 549
  • 4
  • 8
  • 23
0
votes
2 answers

Pentaho : Text file output : Remove CR&LF from last line of the file generated

Pentaho - Design : Text file output Requirement : - Read values from DB and create a csv file. - I want to remove the CR & LF from the last line in the generated file. This empty last line is causing problem while file parsing so I want to get…
Pralhad
  • 13
  • 5
0
votes
1 answer

Extract mail attachment and move to a target folder

My customer wants to send an excel data file (.xlsx) via Outlook mail. And I wish to extract this attachment and put it in a folder on the 'network' for further processing. I wish to use Pentaho for this process. Mail comes --> Attachment Extracted…
Pranjal Kaushik
  • 13
  • 1
  • 10
0
votes
1 answer

Pentaho multiple type conversion from CSV

I have tried pentaho for loading csv file and storing into Database. One of the column in CSV have multiple type values say 2.7777777777777E-06, 0, 2222, 2 , 35.023 My transformation doesn't support type conversion. Please help me for getting this…
sangeeth kumar
  • 319
  • 2
  • 7
  • 23
0
votes
1 answer

carte server error with german umlaut

I am running the community edition from pentaho with Version 7.1 and i am facing a problem which i can't solve. I have a transformation where i use german umlaut like ä, ö, ü because i read in text or define text which contains this letters.…
Armin
  • 11
  • 3
0
votes
2 answers

Pentaho Import uniqe records into database

I am quite new to Pentaho Spoon and I would like to import records of an csv file to an database table. However, only unique records should be imported into the database table. That is why I need to compare EACH record with all records of the…
user7335295
  • 401
  • 2
  • 7
  • 31
0
votes
2 answers

Pentaho Kettle insert Error Handling of step

I am new to GeoKettle (Spoon) of Pentaho and I am currently rows from an Excel-file into my database. Now I want to avoid duplicates in my databasetable. That is why I want to insert only those rows into my database table which aren't there yet (to…
user7335295
  • 401
  • 2
  • 7
  • 31
0
votes
1 answer

How to generate output based on variable in a single spoon transformation?

I am new to pentaho. I am stuck with one issue. I have a spoon transformation. I have an input file with data. Based on the input file, an output file need to be generated. My issue is how to generate output file with different file names based on…
Jince Martin
  • 211
  • 1
  • 3
  • 14
0
votes
1 answer

How to set a default value for a parameter if null?

I need to setup SYSTEM DATE as the default value for my load_date parameter if it is not provided in the runtime. I can achieve this by checking the value passed and assign it accordingly based on a NULL check. Is there an inbuilt feature to achieve…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

Hive jdbc driver not appearing in Pentaho Kettle create new connection

Can someone suggest how to integrate Hive plugin to create a hive database connection in Pentaho Spoon , so that i can fetch the tables and data from the Hive tables and apply transformations.
John Thomas
  • 212
  • 3
  • 21
0
votes
1 answer

convert string value in ate format in java script

i have a problem in converting a string date value into valid date format in pentaho-data-itegration .could someone help me to convert string date'08-Mar-2017' into date format (2017-03-08 00:00:00) in pentaho.
faisal
  • 21
  • 1
  • 5
0
votes
1 answer

Jenkins Pentaho Error

I have a PDI Kitchen job on my server that I run through a script using Crontab on my Ubuntu 14.04 server and everything runs fine. Now I am trying to schedule it using Jenkins (which is installed in the same server) and I get the following…
Diego Serrano
  • 846
  • 2
  • 15
  • 34
0
votes
1 answer

Error with accents to Run Transformation Kettle Pentaho

I have a problem with accents using pentaho data integration to migrate data from sql server to postgresql but just in some cases increases a one symbol. The data type in Sql Server is type Varchar(MAX) and PostgreSQL is type Text For Example: Sql…
Fredy De La Cruz
  • 121
  • 2
0
votes
1 answer

Output row for each input in a column Pentaho Data Integration Spoon

I am new to Pentaho Data Integration, and I am looking to take the below column data and have an output for each entry in the date columns. Not sure how this can be done in spoon. I have looked into the Denormalisation step, but examples are not…
Clint
  • 93
  • 1
  • 2
  • 7
0
votes
1 answer

Pentaho Flow Input->Output->Input not working

I have a Table Input step that retrieves some data form a table A. Data is passed to an Insert/Update step to a table B. For each row inserted/updated, I want to execute another Table Input on table C using one of the field values passed from the…
ed4becky
  • 1,488
  • 1
  • 17
  • 54
1 2 3
…
55 56