kettle_开发者

Kettle: Multiple putRows() in processRow() correctly?

I\'m processing a /etc/group file from a system. I load it with CSV input step with the delimiter :. It has four fields: group,pwfield,gid,members. The members field is a comma separated list with acc[详细]

2023-04-12 04:08 分类：问答

Split this csv/xls into separate files based on two columns?

I have a 35 MB Excel file with these columns: Index, Name, Year, AgeGroup1, Age开发者_开发知识库Group2, AgeGroup3 [...][详细]

2023-04-11 09:03 分类：问答

How can I group steps in Kettle/Spoon?

My Kettle/Spoon (4.1.0) transformation is getting pretty large, it has 30 steps so far. It is using 7 data sources and will produce about 5 outputs. I want to enclose parts o开发者_运维百科f the graph[详细]

2023-04-10 22:30 分类：问答

Kettle Combination lookup step with dynamic key fields (Dimension field / Field in stream)

Pentaho Kettle I need to dynamically set \"Dimension field\" and \"Field in stream\" fields in Combination lookup step of a transformation by using environment variables, it should be something like[详细]

2023-03-27 17:14 分类：问答

JNDI exmple for connecting to a named instance of MsSQL

We\'re using Pentaho Data I开发者_JS百科ntegration(Open source ETL tool) and are trying to use a JNDI connection to connect to a MS SQL 2005 database.If we use a default instance on the server it work[详细]

2023-03-26 19:37 分类：问答

multiple strings as argument in table input

I\'m trying to use SQL like select column from table where column in (?) as ? should be concatenation of strings. I did script, that concatenates rows in something like \'string\',\'secondstring\' and[详细]

2023-03-24 07:20 分类：问答

How to merge 2 csv files by columns in spoon, pentaho, while managing data conversion?

I\'m facing the following problem: I ha开发者_JAVA百科ve two inputs: 1) I have a csv base file with 35 columns and their proper headers.[详细]

2023-03-21 09:34 分类：问答

Are null values in the first column preventing import of Excel files in Pentaho Spoon?

I am trying to import Excel files using the \'Excel Input\' transformation in Pentaho Kettle/Spoon. Spoon spits out a \'NullPo开发者_JS百科interException\' for row 67, which has a null value in the fi[详细]

2023-03-21 05:40 分类：问答

Pentaho-kettle: Need to create ETL Jobs dynamically based on user input

In my application,开发者_如何学运维 user can specify the format of their file. Based on user input we dynamically create SSIS package.[详细]

2023-03-18 11:32 分类：问答

kettle / auto-referencing table

I have an excel sheet with poeple, each people has a father and a mother that is in the same poepl开发者_运维知识库e sheet. My exel table looks like that :[详细]

2023-03-13 04:53 分类：问答