Summary values when joining two seperate datafeeds

Charles Collins on August 9, 2011

I have two tables and there is a common value in each to allow a join. Table one (data feed - one) has been a numeric value on each row. I can produce the sum (grouped on the common value) in a MashApp for each on the tables seperatly. When I try and join these using Combine or Concatatate even though I have over time to resolve this produced a series of datafeeds to filter out all the columns that should just produce a sum at the high level (the common value) but my MashApp still produces the result at row level - why?

Any ideas?

Bookmark

Notify Moderator

7 Replies

Stephan Freudl on August 10, 2011 - 08:27

Based on what you describe its hard to help. Could you post the structure of the two feeds you are trying to join, i.e. combine?

or register to reply.

Notify Moderator

Charles Collins Author on August 10, 2011 - 10:41

I have a data feed that has many rows containing numeric data and also a column that contains a link key to another table (tata feed) that only holds that key at a single row level (many to one retalinship).

In a MashApp I can sum those many rows as a single row which is fine

I am doing the same with two other tables (data feeds) of a similar structure and that is fine too

My issue is that when I try and join the two speperate datafeeds that also have a common key the result in a MashApp is to revert in part back to the single row level and not the summary level I guess because it is the MashApp that perform the Sum and not the data feed. If I could get the sum in each of the datafeeds in a new column probably then that might solve the multiple row issue

Hope that helps

or register to reply.

Notify Moderator

Stephan Freudl on August 11, 2011 - 10:05

Sorry, I still don't get it. May I ask you to post the two feeds you are trying to join as well as the join data feed operator's settings?

or register to reply.

Notify Moderator

Markus von den Driesch on August 11, 2011 - 17:38

Could you please provide a screenshot of the feed definition. This would help to understand your explanation better.

I think, you have to adjust the options of the JOIN operator (here you can adjust how the 1:many relationship should be handled.

Best regards,

Markus

or register to reply.

Notify Moderator

Charles Collins on August 15, 2011 - 12:01

I am sorry if I have not explained it clearly enough. I am new to MashZone so dont know how to post datafeeds or the screenshots as requested - so will try and make it clearer below.

The bottom line is the need to take the sum generated from two datafeeds that have been joined on a common field in a one to many join. To then join that from the results of another data feed that also has the same join structure. I am therfore using 4 raw datafeeds. Because I only know how to sum each set of two datafeeds in a MashApp - and when linking all 4 datafeeds the results in my final MashApp produces a sum at row level whereas I want to see the summary for each key ID only.

I will explain the structure in some detail

One of the summary data datafeeds, Column 1 has an ID title, Column 2 has a description title.
On the datafeed I have in the ID column a row with a 1 and a row with a 2, and a different dedscription on each of the rows.
Ina seperate rows datafeed I have Column 1 with a ID title, Column 2 has a Line number title and Column 3 has a Qty title.
On row 1 I have ID 1, Line number 1, and Qty 36
On row 2 I have ID 1, Line number 2, and Qty 21
On row 3 I have ID 1, Line number 3, and Qty 47
On row 4 I have ID 2, Line number 1, and Qty 33
On row 5 I have ID 2, Line number 2, and Qty 22
I have another 2 datafeeds of the same structure but different ID's and Qtys
On the first two datafeeds the sum of the rows should show ID 1 as a sum total of 104 and ID 2 sum total of 53 - i.e. two rows only.
When joined with the results of the next two data feeds using the description as the common key I want to see the following
Column 1, row 1 = ID = 1
Column 2, row 1 = Description = FIRST
Column 3, row 1 = Qty 104
Column 4. row 1 = Qty (total of Description one's (FIRST) sum for the other two datafeeds)
Repeat calculations on row two
If I had three or more rows in the first set of datafeeds that did not have a link to the second set on the Description column then on those rows there would only be data in the first three columns as detailed above

I hope that helps - please let me know how to post datafeeds and screenshots as I may need to do this still for this query or for any others

Thanks

or register to reply.

Notify Moderator

Stephan Freudl on August 16, 2011 - 09:53

Ah, now I see. For each id/description row there are multiple id/line number/qty ones in the second feed. As Markus indicated, you need the combine data feeds operator to bring both together as depicted below.

Please note, the aggregation operator is optional, you may specify such settings when assigning the feed to a chart.

or register to reply.

Notify Moderator

Charles Collins on August 16, 2011 - 18:09

Many thanks to you both, that has resolved the issue.

Using the results from two sets of data feeds into a final datafeed used by my MashApp table did require the aggregation operator - it was not optional but mandatory because when I used the sum option in the assign data process (this is what I was origionaly doing) it delivered multiple rows - whereas using the aggregation operator in the final combined datafeed it did not - which is what I was trying to acheive

Thanks again

Charles

or register to reply.

Notify Moderator

Summary values when joining two seperate datafeeds

7 Replies

ARIS Roadshow 2025 in Crystal City

PzM Summit Austria

ARIS Roadshow 2025 in Amsterdam

BPM Summit