Profile

James Antony

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 10 of 10 total

RE: Optimal way to join multiple files and output without creating multiple transformations

Posted By James Antony 07-17-2019 13:28
Found In Community: Pentaho \ view thread
Thank you for the suggestion, Johan. I’ve spent some time trying to integrate the metadata Injection step into my solution (never used it before), but I’m having problems getting it to work. My idea was to create a single template transformation that is responsible for joining all the source files (11 ...

Optimal way to join multiple files and output without creating multiple transformations

Posted By James Antony 07-16-2019 15:10
Found In Community: Pentaho \ view thread
I have a task where I need to join multiple files and create a specific output file(s). At the moment I have created around 10 or so transformations to carry out this task(one for each output file). To me this seems quite cumbersome (not to mention tedious), so I would like to know if there is a more ...

RE: How can I calculate the weighted averages based on multiple groupings?

Posted By James Antony 04-08-2019 10:06
Found In Community: Pentaho \ view thread
Update: Managed to get what I want in terms of the fruit analogy. Time to try the solution with my real data.

RE: How can I calculate the weighted averages based on multiple groupings?

Posted By James Antony 04-08-2019 09:19
Found In Community: Pentaho \ view thread
That’s not quite what I’m after, let me try another example, as I think I’ve made a right hash of the one above. Suppose I have the following data grid. I then perform the following grouping Which gives me the sum of each fruit Now that I have the sum of each, I want to place those summations back into ...

RE: How can I calculate the weighted averages based on multiple groupings?

Posted By James Antony 04-02-2019 12:01
Found In Community: Pentaho \ view thread
Thank you again, for getting back to me. Counterparty and term are another grouping, and not part of the sample data, I should have made that more clear. The sample data provided is for two (different) groupings, one by finance type and the other by industry. What you said is correct, I want to calculate ...

How can I calculate the weighted averages based on multiple groupings?

Posted By James Antony 04-01-2019 13:31
Found In Community: Pentaho \ view thread
I asked a similar question a few days ago (https://community.hitachivantara.com/message/43497), which I was able to resolve. However, that was merely to check whether the calculations were possible and was a smaller part of a larger problem In order to calculate one of the weighted averages, the sum ...

RE: How can I calculate the sum of a column, then use that sum to perform another calculation?

Posted By James Antony 04-01-2019 09:43
Found In Community: Pentaho \ view thread
Thank you for this. This might be useful for another issue Im having at the moment.

RE: How can I calculate the sum of a column, then use that sum to perform another calculation?

Posted By James Antony 03-28-2019 13:48
Found In Community: Pentaho \ view thread
I managed to resolve this using a modified javascript step; by keeping a record of the last sum found in the row.

How can I calculate the sum of a column, then use that sum to perform another calculation?

Posted By James Antony 03-28-2019 12:17
Found In Community: Pentaho \ view thread
I need to perform a number of calculations. The first part is to find the sum of a particular column and then divide the sum by its single value in the row. LiabilityBal / Sum of LiabilityBal. Ive created a data grid with some test data, and used a group by step to perform the aggregation. This performs ...

How can I calculate the sum of a column, then use that sum to perform another calculation?

Posted By James Antony 03-28-2019 12:17
Found In Library: Pentaho