Hi, I'm trying generate a text file where i get data from database and need generate a text file with these informations, but this need have a text file layout where my data from database must be in certain position of file, example: id need be in position 14-16 of text file, where they can have a lenght of 3 and must appear in the position…(Show moreShow less)
Hello! I want to take only a part of .txt, its possible? For example, i want just the three lines in the image: Remember that in .txt the lines will not always be in the same position. Someone can help? Thanks!
Consider the filter tab on the text file input... Text File Input - Pentaho Data Integration - Pentaho Wiki Alternatively, if it is a certain row or rows, you could read the file and start with header or stop at row limits and/or filter data in a following filter step.
If you are doing Table Input -> Table Output then you shouldn't run into Out of Memory errors, even for millions of rows. Depending on how many steps you're doing, and what the steps are, you could run into out of memory issues. Talking in hypotheticals is really difficult. Why don't you build your transform, and see if you run into out of…
Hi everyone, I hope you can help me with my issue. The situation is: 1) I receive a worksheet made in Libreoffice Calc and I suppose not modify it, at least manually, since this is impractical. 2) The columns "COLUNA 22" and "COLUNA 30" has formulas and are formatted as minutes ([mm]) 3) The column "COLUNA 23" has numeric data formatted as…(Show moreShow less)
TL&DR: Can anyone recommend a step or method for switching the flow of my transformation in the event that my MongoDB input step comes back with 0 results? More detailed explanation: I want to capture the results from my query in the MongoDB input step as well as events where that query returned 0 results. I had a look at the Switch step, but…(Show moreShow less)
I am having issues when running a transformation which includes Mongodb input on a DEV server. The same transformation runs in production without any issues. Error says that the field cant be found. But the field is available in the collection. Please help!!!!!! DEBUG: Using PENTAHO_JAVA_HOME DEBUG: _PENTAHO_JAVA_HOME=/usr/java/jdk8 DEBUG:…(Show moreShow less)
Getting test result: core-site-xml has no configuration entered. My Hadoop cluster's namenode FQDN:cloud106.scisvlab.local. Also, why hop has It is my first project and pentaho docs are very contradicting.