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
I have a 35 MB Excel file with these columns: Index, Name, Year, AgeGroup1, Age开发者_开发知识库Group2, AgeGroup3 [...]
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
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
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
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
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.
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
In my application,开发者_如何学运维 user can specify the format of their file. Based on user input we dynamically create SSIS package.
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 :
加载中,请稍侯......