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
-2
votes
2 answers

Break string into columns using Regular Expression

I am new in regex, i want to break the give string into 6 parts using regular expression. I am using the Pentaho data integration tool (ETL tool) Given string: 1x 3.5 mL SST. 1x 4.0 mL gray cap cryovial. Note: There are many more string with same…
DHARMINDER
  • 133
  • 9
-2
votes
1 answer

Assign several values to one key Pentaho Kettle

Please help! I have two streams (columns), let's say col_1 and col_2. There are 50 unique rows in col_1 and 10 unique rows in col_2. I need to assign these 10 unique rows to EVERY row of col_2. Actually I need to populate every value from col_1 10…
Ivan Romanovych
  • 51
  • 2
  • 5
-2
votes
1 answer

I have error in a transformation saying Couldn't get row from result set and Unable to get value 'Date' from database resultset, index 2

2016/11/14 09:18:07 - installment.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Unexpected error 2016/11/14 09:18:07 - installment.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) :…
Ujjwal Chowdary
  • 125
  • 2
  • 5
  • 18
1 2 3
…
55
56