Questions tagged as 'pentaho'

Tagged questions
0
answers

Pentaho and Microsoft excel writer

I have problems extracting data from two different layaut in an excel. The problem is that every time I extract the data or I see the data of the second layout (writer 2) but I do not get the first one (writer 1) But once in a while sud...
asked by 19.10.2018 / 11:57
0
answers

How to join several results in a single record ?? PENTAHO SPOON

I have'n' records and each of them has 11 fields that have reference to a txt file, in addition to other fields x of the same record, example: As you can see the reference would be something like des_80_numero.txt , what I'm doing now...
asked by 21.09.2018 / 00:09
0
answers

Insert data from an excel to a table in postgres using Pentaho

I want to insert data from an excel to a table in postgres using Pentaho, but only some fields, not all, the table in postgres has more field, it has 200, but I only want to add the data of the ecxel which are 4 fields, 4 columns     
asked by 13.09.2018 / 15:20
1
answer

pentaho object assigned to variable

I'm trying to assign my javascript method to the value of the http client response, this response is theoretically a JSON object such that. {"457": {"2": {"value": "53.8", "timestamp": 1534257707}, "3": {"value": "21.9", "timestamp": 153425770...
asked by 15.08.2018 / 14:45
1
answer

Problem when creating an Oracle connection from Pentaho Kettle 8.0.0.0-2

I need to connect to an Oracle database from the Spoon and adding all the data requested to create the connection, when doing the TEST, it always tells me that the usr / passwd is incorrect, when in fact all the data is OK . I have an Oracle Dat...
asked by 01.06.2018 / 21:07
0
answers

Insert rows with conditions in Pentaho

I have to do a process with Pentaho spoon and I'm stuck. I think it has to be something simple and I hope you can help me. I start from a table that has some multivalued fields that are separated by a comma. What I want is to create a table w...
asked by 20.05.2018 / 11:49
1
answer

Update values in the ETL from an idpadre

I am using Pentaho 4.3 to make the following transformation: From an excel that contains data on Municipalities and Popular Councils I must insert in my BD the popular advice. The municipalities have already been added before. A municipality has...
asked by 26.04.2018 / 18:03
1
answer

No Start the Pentaho Job Scheduler Community Version 8.0.0-28

I'm trying to automate the execution of a transformation, but it does not run. Can it be a limitation of the Pentaho Data Integration Community? The source of the transformation, I bring it from a remote computer: I enclose an ima...
asked by 05.04.2018 / 20:33
0
answers

tableData [] [] with an id

Good morning, I have the following function: function a(scene){ b = a.tableData[a.rowIdx][0]; } This what you do is get the data from a table in the row that you click but in column 0. I would like to know if you can change column 0 to an...
asked by 15.09.2017 / 15:49