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

Pentaho Kettle (PDI) table input step with field substitution running slower than using literal

I'll go straight to the point. I have a table input step, which reads records with a query that includes a where clause, as follows: SELECT * id, name, surname, creation_date FROM users WHERE creation_date > ? If a put a literal (i.e.…
vantesllar
  • 469
  • 4
  • 13
0
votes
0 answers

Pentahoo - configure dynamic database name

I want to use a table in penthaoo spoon. The table exists, I double-checked it. My connection to database configuration uses dynamics variables, so it shows an error when configuring table exists step. You can see the error…
Hamza Mnd
  • 1
  • 1
0
votes
1 answer

Named Parameters not being substituted in Pentaho Mongo Input Query Expression

I have created a transformation in Pentaho Kettle where I am pulling some data from Mongo Collection, via Mongo Input, but the problem I am facing is I have created two named parameters in the same transformation and they are not being replaced in…
andy
  • 41
  • 1
  • 8
0
votes
0 answers

Named Parameters not being replaced in Pentaho Table Input

I have created a transformation in Pentaho Kettle (5.2 CE), and it is pulling some table data from a data source and dumping into a destination data source. In input table query I am using two named variables (para1 and para2): select col1,…
andy
  • 41
  • 1
  • 8
0
votes
1 answer

Pentaho Wirting to Microsoft Excel

I am using Pentaho to query an Oracle database. My sql and query has worked fine and returned results. However when I add the step of Microsoft Excel Output, it does not output any data that happens to be a time stamp. When I go to the step and…
user4816679
0
votes
1 answer

Pentaho Spoon Transformation - Errors

I have been trying to run a transformation where I have Table Input with SQL to fetch or query data, tied to output for an excel spreadsheet. With the following SQL I get multiple errors depending on what I add or take away. I am connected to…
Joe
  • 31
  • 1
  • 8
0
votes
4 answers

Order step metrics in Pentaho Data Integration

I´m working on a rather long Transformation in Kettle and I put some Steps in the middle of the Flow. So now my Step metrics are all scrambled up and very hard to read. Is there any way i could sort this to be in order (with the direction of the…
coffee_bear
  • 31
  • 1
  • 8
0
votes
1 answer

Pentaho kettle denormalizer or concat

I have one step that I need to concat x rows into one separated by coma or similar. I have this data on my final step: I need to have the "tarifas" row in the same column with the 5 diferent "tarifas" for the same "REFERENCIA" :…
Gerard Luque
  • 163
  • 2
  • 13
0
votes
1 answer

How to run a select sql statement within a field in the Pentaho?

I have a table with a 'query' field containing a select sql and another 'parameters' field containing the sql parameters. I have merged these two fields into a new field containing a correct select sql statement. Now I need to execute this new field…
Carlos Lindberg
  • 23
  • 5
0
votes
2 answers

Pentaho - CSV Input - Incoming field trim type - unexpected behaviour

When using CSV Input utility in Pentaho (V7), we use trim type both to achieve the below. But it doesn't work as expected. Here are the test data and expected output vs actual output |Incoming Data |Expected Output …
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

set value as header using pentaho

I have set of output values as shown below 1,2,3 val1,val2,val3 4,5,6 But I require the header to appear first. output must be like below val1,val2,val3 1,2,3 4,5,6
tester
  • 213
  • 6
  • 20
0
votes
4 answers

Pentaho Data Integration (PDI) How to use postgresql bulk loader? My transformation running forever

I'm new to PDI, im using PDI 7, i have excel input with 6 rows and want to insert it into postgresDB. My transformation is : EXCEL INPUT --> Postgres Bulk Loader (2 steps only). Condition 1 : When i Run the transformation the Postgres Bulk Load not…
blackgee
  • 15
  • 1
  • 6
0
votes
1 answer

Connect Heroku Postgres DB to Kettle

I want to connect kettle to postgres db on heroku for doing an upload of some data. From Kettle I make a new DB connection, in connection type I choose PostgreSQL and I put all the settings that I found on heroku, but the test connection to DB fail.…
Dennis A. Boanini
  • 477
  • 1
  • 5
  • 19
0
votes
1 answer

What is difference between Pentaho DI "variables" and "fields"?

Could not find much information about this. I can see that fields can have multiple copies per row in a transformation. But what are variables? Are they unique across all rows a transformation produces? But, by the name, variables are meant to…
Akshay Lokur
  • 6,680
  • 13
  • 43
  • 62
0
votes
2 answers

How to execute X times a Job Executor step

Introduction To keep it simple, let's imagine a simple transformation. This transformation gets an input of 4 rows, from a Data Grid step. The stream passes through a Job Executor, referencing to a simple job, with a Write Log…
Kapusch
  • 287
  • 1
  • 13
1 2 3
…
55 56