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

The system cannot find the path specified (Batch file) - Using path with white spaces - PENTAHO spoon.bat (pdi-ce-7.1.0.0-12)

I'm trying to execute a batch file "spoon.bat" from PENTAHO (pdi-ce-7.1.0.0-12), but there is an error. Part of batch file where the error is found: if "%SPOON_CONSOLE%"=="1" set PENTAHO_JAVA=C:\Program Files (x86)\Java\jre1.8.0_121\bin\java.exe if…
Khristian Liahut
  • 195
  • 1
  • 6
  • 24
0
votes
3 answers

XPath to select multiple elements

I have an XML as shown below:

000000-000

xxxx

Allen BMC
  • 27
  • 1
  • 1
  • 5
0
votes
1 answer

Left Outer join drops rows in Pentaho DI

I've got two data sets (csv files) which I bring into a Pentaho DI transformation using a "CSV file input" step. File A has a column joincol whose values appear in file B in column joincol. I want to left join the data in file A with the data in…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
0
votes
1 answer

Iterate the input step over different number of files in Pentaho

I have a get file names step with a Regular expression that gets 4 csv files. After that I have a text file input step which sets the fields of the csv, and read these files. Once this step is completed a Table output step is executed. The problem…
mrc
  • 2,845
  • 8
  • 39
  • 73
0
votes
1 answer

How to not export the Slave server connections in the Pentaho XML files?

When I try to export the Pentaho Job or Transformation. It also exports the Slave server connection details and DB connections. I prevented the DB connection information by making use of the JNDI but need help with the Slave server connections.…
Ujjwal Chowdary
  • 125
  • 2
  • 5
  • 18
0
votes
1 answer

Pentaho Spoon Simultaneous execution of same Job

We have created a single Job in pentaho. We want to run this same job from .kjb file multiple times passing different parameters from command line. But as the code is a single source file, we are not able to execute in parallel. What is the solution…
rohitnaidu19
  • 673
  • 5
  • 23
0
votes
2 answers

Problems with text file output in PDI Pentaho

I need help with this trouble. In a transformation I create a text file delimited by semicolons from a table input, but when I look at the file, this shows me empty lines. this is the transform I made: options in text file output And this is the…
SteveKhyuga
  • 1
  • 1
  • 1
0
votes
1 answer

How to connect the QuickBooks (QODBC) data through Pentaho (Kettle) for ETL?

I am trying to connect the QuickBooks (QODBC) application data through Pentaho (Kettle) for ETL process. Would like to know how can we connect the QuickBooks (QODBC) application data through Pentaho.
Rajasekaran M
  • 163
  • 2
  • 16
0
votes
2 answers

How to Enable Logging to a Text file for the Entire job with sub jobs in it in Pentaho

I am trying to store the logs of a Pentaho job that has 10 sub jobs and transformations inside it. I know i can do individually for each job and transformation by going into the settings and writing them to a text file. But i don't want too many…
Ujjwal Chowdary
  • 125
  • 2
  • 5
  • 18
0
votes
1 answer

Get a value of the kettle pentaho flow

I'm working with the pentaho data integration, Spoon. Short description: I want to get the number of times a value has appeared in the flow for each line that reads from the flow. Long description: I am doing the transformation of the fact table,…
Alejandro Reina
  • 273
  • 1
  • 3
  • 10
0
votes
2 answers

Comparing rows count for two different tables Pentaho

I want to compare two row counts for two tables from two different connexions. I've tried to get the number of rows for each different table by executing Select count(*) as count1 from Table1 and Select count(*) as count2 from Table2 in two…
mounaim
  • 1,132
  • 7
  • 29
  • 56
0
votes
0 answers

How to Split column in pentaho spoon transformation

How can I split a CustomerName column in source table into FirstName and LastName columns in destination table? 1) I put Table Input and Table output on canvas 2) Point Table Input to DB1(table:users) 3) Point Table output to DB2(table:customers).…
AlexeiP
  • 581
  • 1
  • 10
  • 26
0
votes
1 answer

How to make a step in pentaho transformation runs twice or more in a day?

I have 1 transformation that contains multiple steps. I want to run one of them twice in a day (every 12 hours). Any idea to make it?
Sandy
  • 210
  • 3
  • 16
0
votes
2 answers

Unable to connect to PostgreSQL through KETTLE-Pentaho

I have pasted below the snippets of Kettle DB Connection Configuration and of PgAdmin PostgreSQL Dashboard. Please advice what I am doing wrong. Localhost and Password are right. Kettle configuration: Snippet of PGADMIN dashboard The error…
user6889125
0
votes
1 answer

Pentaho Data Integration (Spoon) Value Mapper Wildcard

Is there a wildcard character for the Value Mapper transformation in Pentaho Spoon? I've done some digging and only found wildcard solutions for uploading files and documents. I need to be able to map any and all potential values that contain a…
Pat
  • 1
  • 1
  • 1
1 2 3
…
55 56