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

Generate 1 Excel-file with two tabs from two input file in Pentaho

I am trying to develop a job that is able to generate 1 Excel-file with two tabs. Basically, what I want to achieve is: tab 1 is based on input file 1 tab 2 is based on input file 2 I have two input file which contain different query, but end result…
user6186914
  • 31
  • 5
2
votes
2 answers

Unable to pass parameteres to pentaho kjb file

I am new to kettle and am trying to run a kjb file which in turn will execute a transformation(.ktr) file. My kjb file has "Set Variables" element which accepts a file to be read in parameter called "filePath". Now here is my problem: when I run…
KCK
  • 2,015
  • 2
  • 17
  • 35
2
votes
1 answer

Extract data from postgres using bulk loading

CMD.EXE /C BCP "SELECT * FROM ci.trn_td_cash" queryout D:\Sample\data\Load\CASH.COPY -c -t"|" -r"\n" -S xxx.xxx.xxx.xx -d finance -U user -P 1111 . I want to extract data from postgresql using bulk loading BCP command.Can i use BCP for…
Bommu
  • 229
  • 1
  • 4
  • 14
2
votes
1 answer

Removing null values through Cypher Query in Pentaho "Execute SQL Step"

I am using the following Cypher Query in "Pentaho Execute SQL step" to load data into Neo4j Database from the "Excel Input" but while loading there were null/empty values in some columns in Excel.while executing the Query ,Please help me out with…
Haritha Saravanan
  • 29
  • 2
2
votes
1 answer

Spoon takes insanely long time to start

I am running Spoon - Pentaho EE V 6.1 on my laptop (8 GB RAM) and allocated 4 G to Spoon. Still it takes 3 minutes and 30 seconds to start. I dont have any plugins and my plugins directory is empty. I have also tried this by closing all applications…
Srini V
  • 11,045
  • 14
  • 66
  • 89
2
votes
1 answer

transforming rows to headers in pentaho

I have a file which has entried like below FIELD1,FIELD2 name,ABC age,29 location,ZZ name,XYZ age,33 location,YY I require the output to be as below. I tried the row-denormalization, but its not giving proper…
tester
  • 213
  • 6
  • 20
2
votes
1 answer

pentaho set variable to jobs

I am new to pentaho. I have a Job with 3 transformation and all 3 transformation are simliar . In each transformation has Sql query something like select * from table1 where tabl1.col1='XXX' and tab2.col2='YYYY' value of col1 remains same. I want…
simplify_life
  • 405
  • 4
  • 18
2
votes
0 answers

Parsing relaxed JSON without quotes Java

This source Google Finance option Chain Data returns the relaxed JSON, I wasn't able to Parse this JSON through PDI (Pentaho Data Integratio) (originally required) So thought of Parsing it in Java Code. I tried using ObjectMapper and its Feature to…
ankit arora
  • 89
  • 15
2
votes
1 answer

PDI/Kettle: avoid file creation or mapping (sub-transformation) execution

It's clear by now that all steps from a transformation are executed in parallel and there's no way to change this behavior in Pentaho. Given that, we have a scenario with a switch task that checks a specific field (read from a filename) and decides…
jfneis
  • 2,139
  • 18
  • 31
2
votes
0 answers

Kettle : 'Get a file with FTP' is not fetching any files from FTP server

I am using 'Get a file with FTP' in kettle job. I am using active FTP connection and full name of the file as Wildcard(regular expression ) and a remote directory. I simulated the FTP server locally using File Zilla and it does picks up the file…
Praneeth Puligundla
  • 415
  • 5
  • 20
2
votes
1 answer

Pentaho Spoon OK, Pentaho Kitchen ERROR

I currently have a pretty big job up and running on Pentaho Spoon 5.4.0.1-130, but, unfortunately, I keep getting an error when I try to execute the same job on Pentaho Kitchen: 2016/09/08 03:36:05 - Staging Titular.0 - ERROR (version 5.4.0.1-130,…
Isabelle
  • 631
  • 1
  • 7
  • 14
2
votes
1 answer

Automatic column mapping in UPDATE step

For inserts, if source and target columns are the same, no mapping or "select values" step is required. But for updates, there seems to be a need to specify list of update fields. My concern is around manually updating the KTR's each time a source…
kulfy
  • 27
  • 1
  • 7
2
votes
0 answers

Kettle: custom error row in dialog

I'm designing a custom plugin for Pentaho PDI (AKA Kettle). In case of error, my processRow() method sends an error row through putError() with a specific meta layout. The run-time behavior is fine, but when connecting steps at design time, the…
Claudio
  • 10,614
  • 4
  • 31
  • 71
2
votes
1 answer

Unexpected Error when using JSon URL input in spoon

I am trying to import a json in spoon. It works just fine with a file .json but when I try it from a URL I get the Unexpected Error, followed by the java null pointer exception, when executing the transformation. I get the same error with "JSON…
Wallee
  • 21
  • 5
2
votes
1 answer

Pentaho Kettle: changing meta at run-time

I wonder if Kettle (AKA Pentaho PDI) supports metadata changing at run-time. I've implemented a couple of custom plugins: The first plugin sends data to the second plugin. The metadata of the rows sent in output can change when some conditions…
Claudio
  • 10,614
  • 4
  • 31
  • 71
1 2 3
…
55 56