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

pentaho transpose n columns to one column

I want to transpose n columns in inputfields to one…
usef
  • 17
  • 1
  • 4
-1
votes
2 answers

How I can read the file on the everyday basis in pentaho in this format? "tcms_oneed_YYYYMMDD.txt"

I want to read the file from FTP server to pentaho with this particular format. tcms_oneed_YYYYMMDD.txt YYYYMMDD is the sysdate.
Aaron
  • 1
  • 1
-1
votes
2 answers

How to get data from excel and pass excel values as parameters in SQL query on pentaho etl jobs

I'm new to the pentaho etl jobs .. I need to get data from excel and pass the excel sheet value to MySQL query as parameter. If it's possible in etl pentaho jobs .. any know please help me
Sridhar Lovevirus
  • 1
  • 2
-1
votes
1 answer

pentaho set up to AWS Aurora ( mysql ) bastion

I am trying to setup pentaho spoon to connect to AWS auora which on a vpn in AWS. I have access to AWS auora ( mysql ) through a bastion server. It is working with mysql workbench and a simple java program. Connection conn =…
user1441067
  • 17
  • 3
-1
votes
1 answer

"Invalid column name" when "Specify database fields" in table output is unchecked in pentaho PDI V7

I'm trying to insert data to SQL database. I have all the columns in the same order as the data flow. But I'm getting this "Invalid column name name_of_the_actual_data_column" error
Ananth Kini
  • 11
  • 3
-1
votes
1 answer

How do I use Pentaho spoon to push data from MySQL database to facebook webpage

1) I have already made transformation mapping for getting data from specific MySQL (Table Input) and convert it as Text File output. 2) Also I have created a facebook developer account page and trying to figure out how the Facebook API works to…
Sandeep Prakash
  • 1
  • 1
-1
votes
2 answers

JavaScript function to get yesterday date at set time as 00:00:00

I need to create a javascript function to get yesterdays date and time as midnight 00:00:00. For example 2018-08-03 00:00:00. The set.Hours() function is not working in my case. The script is to be used in spoon pentaho data integration. How i can…
Bommu
  • 229
  • 1
  • 4
  • 14
-1
votes
1 answer

Restructuring JSON in Pentaho PDI Transformation

I'm in the process of evaluating several ETL tools for my company and am on Pentaho. I'm finding documentation, tutorials and blogs lacking in the information I need. My use case is simple: I'm going to receive a JSON payload via HTTP, restructure…
nbpeth
  • 2,967
  • 4
  • 24
  • 34
-1
votes
1 answer

Pentaho kettle value conversion

I wanted to convert microseconds to data: 60000000 -> 1997-2-12 (something like this). This means the new field contains year-month-day-hour-minute-seconds-microseconds Thx.
hossein
  • 9
  • 2
-1
votes
1 answer

XML data parse using Pentaho

I have the below xml data. I need data under "additionalList" as an attribute directly. But I am not able to do it using get XML data step. XXUT 38 …
tester
  • 213
  • 6
  • 20
-1
votes
1 answer

How to do third level in complex document from three tables in json to mongodb using Pentaho

I have three tables in one database. These tables have a foreign key between them. Table1 is master from Table2, and Table 2 is master from Table3. I want to get data values and transform in MongoDB document like this: { "_id" :…
Hernan Jesus Guillen Villegas
  • 1
-1
votes
1 answer

Kettle Get Files Names - listing files from a list of folder names

I am trying to something fairly simple: I have a first "Get File Names" step that generates a list of folder names and a second "Get File Names" step that should take the folder names from the first and list the files in that folder. However, I have…
Claus Fjellø-Jensen
  • 1
  • 1
  • 1
-1
votes
1 answer

Add xml parent container elements with Kettle Spoon

I've a mysql table with the header of an invoice. These data are enough to create my xml output file. The structure of the output file must be: …
drenda
  • 5,846
  • 11
  • 68
  • 141
-1
votes
1 answer

Transposing the rows manually

I'm using the denormaliser step, in Targetfieldname column of denormaliser step I want to include 8000 rows, it is not convenient to manually enter the 8000 rows. Can someone help me with some automation?
Deepesh
  • 820
  • 1
  • 14
  • 32
-2
votes
1 answer

is there any query for create table from the existing table in pentaho

I am using data integration tool Pentaho, I am trying to creates not working a big table from the source of an existing table, but it not working its show some error log my code is like create table table_S as (select * from table_A); any…
Sathish Kumar
  • 3
  • 1
1 2 3
…
55
56