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

Pentaho: how to use metedata injection in text file input step?

I am new in pentaho and need some more information from experts. I have a transformation, where I need to read a file and then change the data from it. Problem is that the number of colums in the file can change every time (it can be in this month…
Jane
  • 23
  • 2
  • 5
0
votes
2 answers

Download files from the remote server using Pentaho transformation

is there any way to retrieve a file from a web server using FTP protocol without using "Get A FILE WITH FTP" JOB STEP. I can only use TRANSFORMATION in Pentaho. Any ideas.
Raymond
  • 103
  • 7
0
votes
0 answers

Pentaho How to disable cache?

My problem is when i add some additional jar file into some lib directory of Pentaho Enterprise Edition then I have to restart server to reflect changes. Is there any way so that i can see my changes by avoiding re-start of server? I think it…
Usman
  • 306
  • 1
  • 3
0
votes
1 answer

Pentaho skipping headers, adding filename to output

I need to read a .vcf.gz file from pentaho. I can read it from "Text file input" in "Content" tab setting "compressed" to "GZ". -First of all i need to skip the headers ( basically every row with # at begin). -Second i need to insert a new column…
xCloudx8
  • 681
  • 8
  • 21
0
votes
1 answer

How can I enclose values with double quotes in PDI?

I want to create a csv file as output,but there are some NULL in the stream. I set the Text file output config like this: content tab: separator --> , enclosure: --> " force the enclosure around fields? --> yes fields tab： Null…
Greg Anna
  • 3
  • 4
0
votes
0 answers

Pentaho: How to use dynamic parameters in "Merge Rows diff" step in part Values to compare

I am new at pentaho, I am using a step „Merge rows (diff)“ and compare two tables. Problem ist that I dont know the key and value fields to compare of my origin tables, I can only read them in „Javascript“-step. Do you know any variants how to use…
Jane
  • 23
  • 2
  • 5
0
votes
3 answers

Pentaho | Centos

I am working in Pentaho Data Integretion. We have developed the transformations and Job in spoon. We want to move our code on server and server is Centos. In Centos, we are getting errors while installing UI of Pentaho. We are able to install…
Nilesh Patil
  • 91
  • 2
  • 11
0
votes
1 answer

Pentaho: How to compare two database tables, which have a diffrerent amount of columns and move these columns to other table?

I am very new in Pentaho Data Integration and need your help. I need to compare two database tables, which have a diffrerent amount of columns. For example, firts table A has 3 columns (date, city, country) and other table B has 5 columns (date,…
Jane
  • 23
  • 2
  • 5
0
votes
2 answers

Pentaho:- How to run .kjb files in PHP

I have a below requirement. We want to create one PHP page and want to run Pentaho .kjb files from PHP Page. If we click on RUN button, then PHP should make a call to Pentaho and then .kjb files should execute. Can someone guide how to achieve this?
Nilesh Patil
  • 91
  • 2
  • 11
0
votes
1 answer

Duplicating row in database with list in input

I want to duplicate row in database input based on list. Input: I have JSON string which currently getting sorted in db as per fields. "product": [{"startDate": "2015-02-01T00:00:00Z", "modifiedOn": "2015-03-17T14:12:46.758Z", "parts": ["65",…
Chetan Pagar
  • 1
  • 1
0
votes
1 answer

how to pass a variable from "modified javascript"-step in "sql script"-step in pentaho spoon?

I am new at pentaho spoon. I have written a small javascript, were I have saved a date in a variable. And now I need to use this variable in sql statement in order to delete data from database with this date (everything is done in one…
Jane
  • 23
  • 2
  • 5
0
votes
1 answer

how can I use the variables from one javascript in other javascript in the same transformation?

I am new at Pentaho Kettle. Can someone tell me, how can I use the variables from one javascript in other javascript in the same transformation? In first Java-Script I saved a date in a variable (var new_date) and in the second javascript-step I am…
Jane
  • 23
  • 2
  • 5
0
votes
0 answers

Pentaho mail :- Do not want to display attachment data in mail body.Just want to dispay static message

Good After noon, I am using Mail step of Pentaho DI. I am able to receive mail with attachment files. But I can see those attachment files data and info. in mail body which I do not want. Can anyone suggest me how to NOT include attachment content…
Nilesh Patil
  • 91
  • 2
  • 11
0
votes
1 answer

Pentaho:-CSV file input

I am very new to Pentaho DI. My requirement:- In my CSV file input step, I don't want to select files from browser. I want to pass it through variable or dynamic way. Let say. I have file in "Download" Folder and daily file names get change. So,in…
Nilesh Patil
  • 91
  • 2
  • 11
0
votes
0 answers

"USE DB TO GET SEQUENCE" step is not working in ADD SEQUENCE in pentaho

"USE DB TO GET SEQUENCE" step is not working in ADD SEQUENCE in Pentaho. Even if the connection and schema is correct and sequence is available the 'SEQUENCE NAME' showing no sequence is available. Is there any other way to get the max value of an…
Ms13
  • 151
  • 2
  • 2
  • 14
1 2 3
…
55 56