Merge data from multiple aggregate
Application Type
Traditional Web
Service Studio Version
11.12.8 (Build 52397)

Dear All,


I have a problem building logic in serice studio.

I have two tables where both tables I will group and will merge.

Like the picture below

Help me figure out how I can build that logic.


Best Regards,

Kane

Hi Kane,

Updated for my previous comment:

As I understood correctly, then in aggregate:

1. Add 2 source: Car Entity and Bike Entity

2. Add filter: Bike Entity ONLY WITH Car Entity

join condition: Bike.Color = Car.Color

3. Select Group by Bike.Color

4. Sum Bike.Price (and named it as whatever you wanted)

Cheers,

Khuong

Hi Kane,

According to your tables, I think you can archive by using aggregate:

1. Join: CarTable WITH BikeTable

2. Group by BikeTable.Color and CarTable.Color. Sum BikeTable.Price

3. Add new attribute for MergeColor = 

If(CarTable.Color = BikeTable.Color, CarTable.Color, If(CarTable.Color = "", BikeTable.Color, CarTable.Color))

Note: Using MergeColor to display in UI and Sum of Price.

Hope this helps,

Khuong

Hi Kane,

Updated for my previous comment:

As I understood correctly, then in aggregate:

1. Add 2 source: Car Entity and Bike Entity

2. Add filter: Bike Entity ONLY WITH Car Entity

join condition: Bike.Color = Car.Color

3. Select Group by Bike.Color

4. Sum Bike.Price (and named it as whatever you wanted)

Cheers,

Khuong

Hi Kane Loony,

You can take 2 sources in the single aggregate manipulate it and use it to show it on UI.


Thanks 

Shehroze

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.