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

sql query for monthly amount

I have table like this, SELECT payment_id,amount,payment_date FROM payment To get the monthly total amount, i wrote query as SELECT payment_id , SUM(amount) AS Total , MonthName(payment_date) AS…
Nivedita C
  • 1
  • 2
0
votes
1 answer

How to schedule a pentaho transformation/job using crontab

Can anyone please provide me a step by step procedure for scheduling a pentaho job/transformation using crontab.
sree
  • 3
  • 7
0
votes
2 answers

Pentaho spoon error: "Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."

I'm new in Pentaho environment. I installed pentaho CE recently on another computer and couldn't preview a simple mongoDB input step result which fetches data from mongodb. It is giving me the following error message: Blockquote …
Elias Gezahegn
  • 55
  • 6
0
votes
2 answers

number format in pentaho report designer

I am working on pentaho report designer HereI created one cross tab report. When I preview the report it is showing me results as below name total A 598.00 B 273.00 c 124.00 d 0.23 e …
sree
  • 3
  • 7
0
votes
0 answers

Loading fact table with dimension key that are not in stream

I want to load fact table and one of my dimension is not in the stream and I want to store that dimension key to my fact table when my transformation runs. Issue is that dimension key is not present in my stream then how can I compare my key to…
Adil
  • 11
  • 4
0
votes
1 answer

I want to create transformation in which I want to add multiple inputs table column value into one table in the same column in pentaho

I want to create transformation in which I want to add multiple inputs table column value into one table in the same column in pentaho e.g Two input products table having id and name and one output table with id and column wants to add all values of…
Adil
  • 11
  • 4
0
votes
0 answers

Deleting records from fact table and dimension table

I want to delete records from target table as records deleted from a source. I used merge/rows and delete stop both individuals, but I solved my problem in delete case when I deleted record from source. Then, after transformation fact table had only…
Adil
  • 11
  • 4
0
votes
1 answer

Does "Delete" step in pentaho kettle lock table until it finishes deleting the records from the table?

I have a requirement where a large amount of records need to be deleted from a table using pentaho ETL job. I know it can be easily implemented using delete step in a transformation, but i am afraid of using it as Delete step can lock the table for…
Krishna Gond
  • 143
  • 11
0
votes
1 answer

How to check if the file contents exist in Kettle PDI

I have a job at Kettle that send an email based on a csv. But sometimes that csv have no content, and I would like to know how can I only send the email when the csv file isn't empty.
mvitti
  • 3
  • 1
  • 3
0
votes
1 answer

Add an Update SQL Query on a Pentaho Kettle Transformation

I have a scenario where I would like to run an update script after a table input and table output job, can anyone assist? I have tried these four but I can't seem to figure out how to make them work. My Current Transformation Here's the…
Kenince E'm
  • 13
  • 6
0
votes
1 answer

Kettle PDI how to define parameters before Table input

I'm converting data from one database to another with a slightly different structure. In my flow at some point I need to read data from the first database filtering on the id coming from previous steps. This is the image of my flow The last step is…
drenda
  • 5,846
  • 11
  • 68
  • 141
0
votes
1 answer

Converting Time into Minutes in Pentaho (PDI Script)

I want to calculate sum of activity time(HH:mm:ss) for various transactions in PDI. For example, consider 3 activity times: 1) Activity 1 - 01:22:03, 2) Activity 2 - 01:10:11 and 3) Activity 3 - 00:22:20. The sum of all this time should be…
ParagCreative
  • 1
  • 4
0
votes
1 answer

Calculating summary for rows and columns in pentaho report designer

I am creating a report with some data like below: 1/1 1/2 1/3 1/4 A 2 1 2 1 B 4 5 6 8 For the above data i would like to summarize each column and each row totals like below. 1/1 1/2 1/3 1/4 A 2 1 …
user8922081
0
votes
1 answer

Errors relating to date data type using Pentaho Spoon

I am reading a CSV file with information about tweets using Spoon. There is a created_at field at which time the tweet was sent. However, the format is varied, with some examples being 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'MM/dd HH:mm' and…
AshNaz87
  • 376
  • 3
  • 14
0
votes
2 answers

Merge two mongo collections with query condition in pentaho

I have a problem querying two collections and combining the results to form another collection. Collection1: { "ResourceCost" : 0.0032258065, "ResourceId" : "i-08c35f123eea43f30", "Unit" : "USD", "billdate" :…
sangeeth kumar
  • 319
  • 2
  • 7
  • 23
1 2 3
…
55 56