Category "pentaho-data-integration"

Using multiple wildcards in Pentaho spoon for subdirectory paths

I was trying to use the GetFiles step to retrieve all files that are type .xlsx having sheet in the filename and having common names in the subdirectories path.

Pentaho spoon search and replace especial character in rows

I have a csv file with mime type US-ASCII and one column in the dataset look like this: id V_name 210001 cha?ne des Puys 210030 M?los 213004 G?ll? 213021 S?pha

Pentaho spoon search and replace especial character in rows

I have a csv file with mime type US-ASCII and one column in the dataset look like this: id V_name 210001 cha?ne des Puys 210030 M?los 213004 G?ll? 213021 S?pha

Pentaho API - Cannot resolve paths to transformations in job?

I have a job I've built in Pentaho 9.1 that contains many transformations. All of my .kjb and .ktr files are in a local file repository, and have been exported

Replace All references to email Pentaho Jobs error checking in Repository

I have over 100 jobs (kjb) that reference an email address that is no longer active. I wish to globally change the email address dynamically using PDI (spoon) i

CPython Script Executor does't work on Pentaho Kettle

Hellow Guys First of all, i'm using the windows 10, java_1.8.0_333, and Pentaho 9.3 I'm trying to many ways to run my Python code in Pentaho, but isn't work. I

how to using parameter in modified java pentaho

my boss wants to send email every morning with filename+date(yyyymmdd) i've used "get file names" in the folder. the problem is, the filename in "get file name"

How do I put a success step to a job when there are parallel transformations?

I have a job which includes sequencial 3 jobs that each makes around 20 parallel transformations. If I have a success step for each transformation the success s