Profile

Alejandro Ramos Alvarez

Contact Details

My Content

1 to 6 of 6 total
Posted By Alejandro Ramos Alvarez 02-09-2024 09:22
Found In Community: Pentaho
\ view thread
How do I group by the origin_contract_id after join by origin_contract_id? another step?. I need group by origin_contract_id and sum all token_id
Posted By Alejandro Ramos Alvarez 02-09-2024 08:27
Found In Community: Pentaho
\ view thread
Hi @Petr Prochazka In dbeaver and i expected: In spoon: TOKEN_ID = CODE KTR:
Posted By Alejandro Ramos Alvarez 02-09-2024 07:28
Found In Community: Pentaho
\ view thread
Hi, I have this sql query: SELECT ORIGIN_CONTRACT_ID, COUNT(*) FROM(     SELECT         ORIGIN_CONTRACT_ID,         CREATED,         NTYPE     FROM BILLING     WHERE NTYPE IN (1, 73)     AND ORIGIN_ID = 2     AND EXTRACT(YEAR FROM CREATED) = '2023'     AND CODE IN (SELECT TOKEN_ID FROM REQUEST WHERE ...
Posted By Alejandro Ramos Alvarez 10-10-2023 10:26
Found In Community: Pentaho
\ view thread
Hi, I have a job with a .ktr that insert/update registers this way: I want to update records based on the 4 fields above. The id field is the primary key. If some of the 4 fields to be updated are different from what is in the table, do the update, otherwise do nothing. 98% of registers will do nothing. ...
Posted By Alejandro Ramos Alvarez 01-19-2023 07:32
Found In Egroup: Pentaho
\ view thread
We are running pdi in Ubuntu 18.0.4 LTS. I'm checking your advice. but the problem occurs for me also when spoon its not running a job o transformation, just working with it. Thank you very much for your help. ------------------------------ Alejandro Ramos Alvarez Data Service Manager Logalty --- ...
Posted By Alejandro Ramos Alvarez 01-19-2023 04:37
Found In Egroup: Pentaho
\ view thread
Same problem here. I hope someone can help us ------------------------------ Alejandro Ramos Alvarez Data Service Manager Logalty ------------------------------