1,408 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
72
views
Pentaho Kettle Database Join Alias problem
I am using kettle version 9.4 and migrating some jobs from 5.0,
i have an issue with step Database Join, in which i write a simple query that retrieves a column as alias, example:
select u.user_id as ...
0
votes
0
answers
71
views
Kettle10.2 cannot use the database repository
I have installed Kettle10.2, but I am unable to find the connection options for the database repository. May I ask if this feature was removed in version 10.2?
I compared it with version 9.4 and it ...
1
vote
1
answer
64
views
How to create or insert data into a table that has no unique values using 2 different tables which also has no unique valus?
I have 3 tables.
Pin Code Master
Pin code temp
City temp
in pin code columns are
entry id - number
picode - number
state - number
district - number
pin code temp is same as master
city temp
entry ...
0
votes
1
answer
6k
views
How to download previous versions of pentaho-data-integration CE(kettle)? [closed]
Below is the official download address for the open source community version:
https://pentaho.com/pentaho-developer-edition/
But I found it only provide the lastest version, and can not choose the ...
0
votes
1
answer
74
views
How can I import data from several sources to a single output file with Pentaho?
I have a transformation process that gets data from several data sources and joins them into a single CSV output.
This process is a raw job that removes the previous information and loads the data ...
0
votes
2
answers
71
views
How can I mask all tables for all Transformation in Job?
In my Pentaho Data Integration (PDI) workflows, I need to copy data from Database A to Database B. so I use copy tables function to do it. copy tables function
However, before writing the data to ...
1
vote
1
answer
97
views
Pentaho: How to dynamically modify rows?
I have a table with population counts over the last 25 years approximately. Of different towns and cities. I also have a table with additional data about most of each of those cities, so I performed a ...
1
vote
2
answers
137
views
Read csv and get table data and write as text file output
I have a csv file which has the below mentioned data of Table names in a sql server instance in ubuntu.
Tables
TableName1
TableName2
TableName3
.
.
.
I want to read this csv file and I want to get ...
0
votes
1
answer
71
views
I'm trying to add a header to the output file in pentaho but the column names from the actual data that I am writing are getting removed from file
I am trying to write some data into text file but before that I want to write about the type of the data being written to the file.
eg.
This is the data about City and country
City~Country
Mumbai~...
0
votes
0
answers
502
views
Pentaho Data Integration (PDI) Jobs Failing After Upgrading to OpenJDK 11 on CentOS VM
I recently upgraded my Java version from 8 to 11 (openjdk 11.0.22 2024年01月16日 LTS
) on a CentOS virtual machine where I run Pentaho Data Integration (PDI) jobs. According to documentation, PDI 9.3 ...
0
votes
1
answer
50
views
Transform XML with meta columns to csv in PDI
I have the below XML structure as input (number of columns/fields and rows can change based on query)
<?xml version="1.0" encoding="UTF-8"?>
<response>
<results&...
0
votes
1
answer
117
views
Get row number from stream to perform concat
Can we simply extract the row number from stream in Pentaho Spoon to perform a concat operation with it, for example?
Let's consider we have:
#
Country
RowNum
1
FR
null
2
BE
null
Here I want to ...
0
votes
1
answer
109
views
How to add condition in Pentaho Spoon
I'm trying to insert a record from a .csv file that is not present in Table. How do I add a condition where it filters the record such that if it's present in the table, it would not be inserted?
...
-1
votes
1
answer
151
views
Pentaho: Multiple excel in folder to a excel [closed]
I've successfully input multiple Microsoft Excel files from a folder. How can I save all of them into one Excel file?
referensi input : https://stackoverflow.com/a/66865749/23392458
I want all Excel ...
0
votes
1
answer
306
views
Issue with Channel Log Tables in Pentaho Data Integration V7: Works in Manual Execution but Not in Nightly Batch
In Pentaho Data Integration (V7), we have activated Kettle's own log tables to generate an error reporting system. So far, we have activated the Job, Transformation, and Channel log tables:
In the ...