Questions tagged as 'pentaho-spoon'

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 of type OpenERP Object Output to Odoo Using Pentaho

I am trying to insert some data in Odoo using Pentaho, OpenERP Object Output, the data I am loading from an excel, they load well, but the error is in the moment of inserting them in the table in Pentaho, these are the errors what gives me 2018/...
asked by 14.09.2018 / 22:14
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

pentaho error PDI using spoon with mysql

make a successful connection to a Mysql database but when I try to make a new transformation using a table_input when I click on preview I get the following error.    2018/06/29 15:12:10 - Carte - Installing timer to purge stale objects   aft...
asked by 30.06.2018 / 19:12
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